Table with IDCustomer and different primary key

[raphael99]

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.

 

[Trevor G]

You might be success if you use a Junction Table which creates a Many to Many relationship. Take a look at one of these YouTube videos to see if it provides you with a solution

https://www.google.co.uk/#q=access+create+a+junction+table+youtube

 

[raphael99]

Thanks Trevor but I need an hint on how building tables and give them the right primary key.
I have ID customers 1000 rows that is in junction with table customers.
In the same table in which I have IDCustomers I want to have an ID product with primary key 15 rows.
Access won't let me name Id product because a null value. That one is numeric and it is numbred from 1 to 15.
I'm getting crazy

 

[jdraw]

I'm going to suggest this tutorial from Rogers Access Library to help you with Tables, relationships and keys. You have to work through the tutorial, but it does have a solution.
Good luck.