Very Basic Question about Relationship DBs

[leeandrobin]

Please help with a very basic question? I have two databases for common customers (one with contact info and the other with specifics of their orders). How do I link them? I apologize for the probably simple question.

Thank you.

[Kurt Knippel]

Create a Unique ID in the customer file and have a field to store that in the Order file.

[Reed]

The best way to do it is to have each contact record have a unique auto-enter serial number field. (this is called the primary key). Then each order record would have a field which identifies which contact record it is related to. (this is the foreign key) In FMP5, you create a relationship from one file to the other where the two fields mentioned equal each other. In FMP5 you have to create the relationship in both files in order to use it in both directions.

If you can't figure it out, you could post a clone of your files (no records) and I could make the connection for you.