Validation Rules for Data Integrety

[Faction21]

Validation Rules for Data Integrity

I have a field that looks up the JobType using a LookUp Combobox from another table where these records for JobType will never change.

I want the user to only be able to select from the Combobox for the job type they want and be able to type the beggining of the job type so that the desired job will pop up. Now, i need the field to not be able to accept any other data than what is in the LookUp, so that they cannot enter false values. Duplicates of jobtypes are possible so a primary key cant be used.

Any help guys?
-thanks

 

[Pat Hartman]

and be able to type the beggining of the job type so that the desired job will pop up

- This is the default behaviour of the combobox. Set the LimitToList property to yes to prevent items not in the list from being added.

Also, whenever you have a relationship between tables, you should define it formally using the relationships window and choose the Enforce Referential Integrity option. The LimitToList property is only going to work for the combo on the form where you defined it. RI will be enforced no matter what so it is very important to data integrity to use the features provided by Jet.