Link tables in Base

I am trying to build a small database to link vendors (last name, first name, phone, email, business name, craft) to vendor registration (Registration Sent Date, Rec’d Date, Tables Requested, Table Type, Paid, Confirmation Sent Date) to vendor requests (special requirements, location). I would like to have a primary key of vendor id generated (I know how to do this). I don’t know how to link these tables using the primary key.

I have read a lot of the recommended documentation and questions and answers. I haven’t been able to find a solution. I think it is probably pretty simple. Any help would be appreciated.

You will need field, which should contain the foreign key (same field type as primary key). If primary key in table1 is (“ID”) → INTEGER you will need a field in table2 for (“table1ID”) → INTEGER.

No open Tools → Relationships, choose the tables and draw with mouse from “table2”.“table1ID” to “table1”.“ID”. Now you have linked the tables. “table2”.“table1ID” could only save values, which have the same value as “table1”.“ID”.

[Example] Relations reflected by list boxes in forms includes an example database with a one-to-many relation between persons and animals (each person belongs to one animal) and a many-to-many relation between persons and things.
See relations window and the form navigator window of the respective form.