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.