Hello all,
I have a table(2) where I would like to use an integer as a primary key and use the same number more than once since I have multiple entries on table 2 linking back to another table (1) where the same matching key # resides to ID the relationship.
Since the primary key function doesn’t allow use of the same number more than once I sought to get around this by having 2 integer columns and joining them as a dual primary key. I wanted to make the column linking back to the related table a non auto value and make the second column an integer auto value which would also give me a way to count my entries and manage the order they show up on in the table.
What I find is that once I try to set a primary key the integer auto value will not work on a second integer field…throws an error when I attempt a save.
Is there a way around this? I have multiple entries in my second table that link back to the first table…and the only way I know to do this is make sure the related integer for each entry is the same on both tables…I’m stumped.
Any thoughts would be greatly appreciated…
SC