Hi all
When creating a table, I make an autonumber column so I can make it primary key. Then I'll use that number when making relationships. But look at the following.
I have rows that I'd like to reference as:
1.1 | some field | some field
1.2 | some field | some field
1.3 | some field | some field
1.4 | some field | some field
2.1 | some field | some field
2.2 | some field | some field
2.3 | some field | some field
2.4 | some field | some field
3.1 | some field | some field
3.2 | some field | some field
3.3 | some field | some field
etc....
What would you recommend as far as creating a primary key?
An autonumber column,
A unique decimal column (ie 2.1,2.2 etc),
or combine two indexed columns like
1 | 1 | some field | some field
1 | 2 | some field | some field
etc.
By the way, that first number in 1+n.n is a foreign key to another table.
Sorry if this sounds confusing. I just want to know if you can combine two columns to make a unique key. If you can, are there any drawbacks.
Thanks
