(ahmmm, looking around the room for an obvious answer, so I don't have to write and SQL...)
Maybe the controling index on the child table could just be set to descending? That way the last record will be on top?
>Just wondering something. I have a classic parent child one to many relationship, Lets just say an Invoice has many detail items. Is there a way to SEEK() for something in the parent table, select the related child table, then go to the last record for that Parent table record? When I do this I get the actual last record in the child table not the last child record for the related parent record. Is the only way to do this sort of thing with a SELECT-SQL or am I missing something
>
>Much Thanks
--Todd Sherman
-Wake Up! Smell the Coffee!