Originally Posted by shaunthomson
Thanks makes sense. Thanks Felgall.
Can you use three columns that are unique together as the primary key, or is that not workable?
If a table is just one column, how can it relate to any other tables - how do you create a relationship?
You can have three columns in a key.
A one column table would need to have its column as part of the key in the other tables that refer to it. Its purpose would be to limit the values that can be contained in that column in the other table(s) to the values in the one column table.
Helping others to solve their computer problem at http://www.felgall.com/