Hi Chris,
for SET ORDER iacc has to be a tag, for SET RELATION it has to be a field in customers.
SELECT ChildTable
SET ORDER TO SomeTag
SELECT ParentTable
SET RELATION TO
field_in_parent_table TO ChildTable
It must be possible to compare
field_in_parent_table with the tag the childtable is ordered by.
The child table will display the records where the index SomeTag is even the value of
field_in_parent_table in parent table. Parent Table don't need to be ordered or indexed.
HTH
Agnes
Update:
field_in_parent_table dont need to be a single field, any expression that you may use in an INDEX will be o.k.
Agnes
>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
>>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
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord
Weeks of programming can save you hours of planning.
OffThere is no place like [::1]