General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only