changing relationship type

[aymanmb]

realtion between category table and products table should be one - many. when i make the relation, it is always one - one.

this is of course making impossible to have 2 prdoucts with same category in the products table.

attached is my current table relationships, please guid me for a fix if applicable

thanks

 

[boblarson]

What datatype is CategoryID? It should be Autonumber in the Category table and Long Integer in the Products table.