primary key

[Guest]

how do you choose a proper field so as to be set as a primary key?
thanks sharon

 

[Joseph Meehan]

how do you choose a proper field so as to be set as a primary key?
thanks sharon

You would choose or create a field that would be unique for each record.
That is there is and will not be any duplicates. Normally you would want
that field to be small, like a number but there is no requirement.

 

[Guest]

You would choose or create a field that would be unique for each record.
That is there is and will not be any duplicates. Normally you would want
that field to be small, like a number but there is no requirement.



--
Joseph Meehan

Dia duit

so if u had 4 fields: product ID, product name, discontinued and Unit price, the obvious ans would be product ID right?

 

[Guest]

You would choose or create a field that would be unique for each record.
That is there is and will not be any duplicates. Normally you would want
that field to be small, like a number but there is no requirement.



--
Joseph Meehan

Dia duit

so if you had 4 fields say product ID, product name, discontinued and unit price the primary key would be product ID right?

 

[Joseph Meehan]

so if u had 4 fields: product ID, product name, discontinued and
Unit price, the obvious ans would be product ID right?

Likely. You would want to check to make sure there were no duplicates.
Likely you would want to do that anyway.