>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.