Relationships Between Tables In Data. As you can see in the picture above the customer_id column is a primary key of the Customers table. Determine which tables to specify in the relationship.
To fix this I link them each to another Products Table that contains only the unique prouduct values. I am trying to create a relationship between two tables that both have duplicates. There are several reasons why you should create table relationships before you create other database objects such as forms queries and reports.
It is crucial from a data-integrity standpoint because it helps to eliminate duplicate data and to keep redundant data to an absolute minimum.
1 It establishes a connection between a pair of tables that are logically related to each other. In my case I have two tables. Relationships specify the connection between tables and enable you to pull data together in meaningful ways. Relationships are the flexible connecting lines created between the logical tables in your data source.
