Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Where's my relationship ??
Message
From
12/12/2001 07:26:12
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00593120
Message ID:
00593164
Views:
25
>Jimmy,
>
>When you put the two tables in the DE of the form Fox set up the raletionship that is in the dbc. You actually want the reverse relationship in the form. So you can open teh form's DE and click on the relationship line then press delete key to remove the relationship. Once you have done that you can click on teh feild in teh Article tabel and drag it to the index in the Category table. That will set your relationship in the direction you need.
>
>All relationships have a parent and child table in them. There is the table that the relationship originates from (Parent) and the table that the relationship is trargeted to (Child). For the sake of referential integrioty (your relationship in the DBC) the category table is the parent and the article table is the child, however in your form you want the relationship reversed so the Article is the parent and it is controlling the movement in the category table. Thus you need to remove the relationship Fox defaulted to for you and set the one you actually need.

Thanks for the reply,

The problem was I made an index on the field from the parent-table that should by linked with the child-table.
Because I made this index I could not create this relationship.
Previous
Reply
Map
View

Click here to load this message in the networking platform