Two primary keys in a table

[developing]

hello,

I had the need to create a table with 3 columns that are allowed to have same values except there can be only one particular value in column C for any combination of column A and B.

Eg:

A B C
1 6 7
1 5 4 <-Valid
9 6 3 <-Valid
1 5 2 <-Invalid because there are two values for when A=1 and B=5

I know access doed not allow two primary keys in one table, so i made a switchboard table and used it as my table (It has two p keys)

I can edit the data in this table no problem. When I try to do this using a form, it doesnt work....ideas? or things i should know about? just throw em at me...

[developing]

never mind..figured it out....finally getting the hang of access

[MMcCarthy]

never mind..figured it out....finally getting the hang of access

That's good to know. :)

For future searches by members can you post how you solved your problem.

Mary

[developing]

for sure, select both fields and assign them as primary key


if that doesn't work, make a switchboard table and edit that table to suit your needs.

Switchboard table uses two primary keys