When i replicate the catlogs are destroyed.

i'm an idiiot. i thought i had tried that and in fact  i had but while doing it i screwed up something else.

Thanks a billion for your help and patience.

I...

when i run this

Select feature_id feature_text,feature_sequence, publish_startdate

From homefeatures As f

Inner Join

  (   -- virtual table

    select  max(publish_startdate) As MostRecent, feature_sequence

    from homefeatures

    group by feature_sequence

  ) vt

On (vt.feature_sequence =...

here's the actual query i'm running

i goofed to column names in my initial post but its the same deal really

SELECT feature_id, feature_text, feature_sequence, publish_startdate

FROM homefeatures A

WHERE publish_startdate = (SELECT...

Sorry for being vague

Feature sequence is indeed a number from 1 to 4 that controls the order in which my 4 features appear on a homepage.

the page always has 4...

i was hoping to return a dataset with 4 rows one for each feature position.  Do i need to set rowcount?