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