>>I think you don't have a field named iacc in table CUSTOMERS.
>>
>>Dino.
>
>It's the index of the child table. The SET ORDER TO TAG iacc works OK, do I need an index in both tables with exactly the same name?
>
>Thanks
Chris,
PMFJI but it should be a field (or combination of fields) in parent not a tag in child.
ie:
CustomerTable : pkID, otherfields (parent)
OrdersTable : customerID, otherfields
use CustomerTable && This doesn't need an index to be set or exist
use orderstable in 0 order tag customerID && Child needs a matching index
set relation to pkID into ordersTable
IOW you set a relation from field(s) in parent to a tag in child. If not order is set in child and relation field is numeric then relation is set between the field and recno('child').
Cetin