Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Relations between tables
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00169995
Message ID:
00169998
Views:
14
>Is there a way to visually set up relations between two tables in the database
>designer? I have two tables containing company id fields and would like to set
>up a relationship for them.

In the database designer, you need to create the link between indexes, rather than the field names. One of the indexes must be a Primary Key.

Bear in mind that this will not automatically link them, but it will support Referential Integrity (can't delete a company that's still being referred to, frex), and the Form Designer will also pick up on them.
My blog
My consulting page
My home page

Member of the Trim Your Auto-Quote Campaign!
What's another word for thesaurus?
Previous
Reply
Map
View

Click here to load this message in the networking platform