Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SET RELATION TO - variable not found problem
Message
From
27/06/2003 06:26:08
Lutz Scheffler
Lutz Scheffler Software Ingenieurbüro
Dresden, Germany
 
General information
Forum:
Visual FoxPro
Category:
FoxPro 2.x
Miscellaneous
Thread ID:
00804574
Message ID:
00804583
Views:
34
This message has been marked as the solution to the initial question of the thread.
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.

Off

There is no place like [::1]
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform