Hi, I'm novice and trying to undeerstand.
I got a product table that I want to link with Customer Table.
To relate one to many I have a IDCustomer on my product table that is about 1000 rows.
I can link and all is working.
But in the product table I need a Primary Key that is shorteer in rows (only 15 rows) and access won't let me create such a primary key because it contains null value.
How to solve this problem.
I Need Product ID (as primary key) to relate to another table which I will name Product details.
I got a product table that I want to link with Customer Table.
To relate one to many I have a IDCustomer on my product table that is about 1000 rows.
I can link and all is working.
But in the product table I need a Primary Key that is shorteer in rows (only 15 rows) and access won't let me create such a primary key because it contains null value.
How to solve this problem.
I Need Product ID (as primary key) to relate to another table which I will name Product details.
Table with IDCustomer and different primary key
0 commentaires:
Enregistrer un commentaire