I would want to create a table that reference 2 different tables. Does Access allow to do that? For example: a service_agreement table contains contract_number that refers to contract_table, it also has vendor_id that refers to Vendor_table. Is it alright to do that?

Can someone help to answer this question?
Thank you,