Composite Key and Input

[JohS]

Hi

I'm using a Composite Key of 3 indexes and am using 3 ComboBoxes to input.
But as I'm putting in new data into the fields I would come to the last
ComboBox and then I would have the message of that this record exist from
before (I'll have this message: "The changes you requested to the table were
not successful because they would create duplicate values in the index,
primary key, or relationship."). How could I prevent this from happing? Do I
need a VBA function to test if all these 3 input ComboBox data already
exist, and then just let them be populated, or if not add into a new record?
(Or is it any adjustment (some kind of form function) I could do inside
Access's own properties). Thanks, JohS

 

[pietlinden]

Hi

I'm using a Composite Key of 3 indexes and am using 3 ComboBoxes to input.
But as I'm putting in new data into the fields I would come to the last
ComboBox and then I would have the message of that this record exist from
before (I'll have this message: "The changes you requested to the table were
not successful because they would create duplicate values in the index,
primary key, or relationship."). How could I prevent this from happing? Do I
need a VBA function to test if all these 3 input ComboBox data already
exist, and then just let them be populated, or if not add into a new record?
(Or is it any adjustment (some kind of form function) I could do inside
Access's own properties). Thanks, JohS

One thing you could do is use the find Unmatched query wizard to
figure out which values have not been used... then you can only choose
these values. The rest would be eliminated from the combobox.

 

[JohS]

Thanks

One thing you could do is use the find Unmatched query wizard to
figure out which values have not been used... then you can only choose
these values. The rest would be eliminated from the combobox.