Hello
I see an issue with the definition of the primary key.
I recommend you to take a look at this:
http://en.wikipedia.org/wiki/Unique_key[
^]
I recommend you to define a single field Primary key with autoincrement (if you decide to use a numeric field), and if you want to constraint some kind of field combination, I recommend you to use Unique Key constraint (additional to Primary Key).
When you define the primary or unique key, you will be able to reference the table on another table.
I'd like to see your Data Dictionary to see how you define and use this fields and how you constraint them.
If you still have any other question, please fell free to ask.
Best Regards.
Aner