>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
Usually, SET ORDER TO INVOICE DESC in the child table will list the last item first if, from the parent table, you SET RELATION TO INVOICE INTO CHILDTABLE.
Mark McCasland
Midlothian, TX USA