Hello,
I have no experience in using access and after making a table in it that had five fields it asked me to choose one field as a primary key. The problem is that the table (which represents a tyre) can not be described with one primary key.
Lets say i have these fields :
-size
-company
-quality
-date
-quantity
A tyre should be uniquelly defined by a combination of the first four fields of this table,it can not be described with one primary key of only one field.
Even if we change one of the first fields we geta new tyre.
Also the last field called quantity is irrelevant to the uniqueness of a tyre.
So how can i define the keys to do it? Since i am new the simpler way would be best.
Thanks.