Access Relationships Between Tables. And I would like to create relationship between them. Click the Database Tools tab on the Ribbon.
MS Access uses table relationships to join tables when you need to use them in a database object. In order to eventually create a relationship you must make sure that when you design your tables that you include a common field in both. Click the related field in the first table and drag it to the related field in the second table.
Now lets look at the different types of table relationships.
It is possible to add a table more than once. An association established between common fields columns in two tables. Click the related field in the first table and drag it to the related field in the second table. In a One to One relationship each record in a table relates to one record in another table.
