Form data Validation (1 Viewer)

[c-bert]

I have a form with 7 combo boxes. None of them are unique keys but I don't want the same comination of info put in twice. How do I do it!?

Basically I have:

Manufacturer
Equipment Name
Document Number
Document Section
and a couple of numerical ratings.

I don't want the same Manufacturer, equipment , doc number AND doc section repeated twice.

 

[dynamictiger]

One possible solution could be to create a combined Primary key. This will work in Access XP I am not so sure about previous versions of Access.

 

[c-bert]

Well, assuming I knew how to do that I'm using only Access 2000. D'oh.

 

[dynamictiger]

Try, unselect your current primary key. So your table does not have a primary key, you may have to destroy a relationship or two to do this. Then choose the primary key button and drag across your four fields in design view.

 

[c-bert]

I don't think you can do that in 2000. Also its a form I've got the problem with, not 1 table. The entries are drawn from a couple of different tables.....

 

[dynamictiger]

That's why I said one possible approach as I wasn't sure if your form was based on a table or not.

 

[c-bert]

I've managed to sort it by using multiple primary keys. All the important stuff from the form was in 1 table so I made them all primary keys.

Cheers mate!