Search results

Restrict the entries how exactly?

As far as I can see the Form Validation only restricts the entries to "M" or "F" but doesn't ensure consistency with "Mr", "Mrs" etc.

I am looking for a solution to this problem, does anyone have the answer?

I need to ensure that "Mr" in Title always = "M" in Gender and "Mrs", "Miss" or "Ms" in Title always = "F" in Gender. I am limited in the number of tables I can use therefore none of the solutions suggested so far can be used to ensure consistency.

I need to ensure that "Mr" in Title always = "M" in Gender and "Mrs", "Miss" or "Ms" in Title always = "F" in Gender.

I can't see why I can't put all Employee details in one table? I have 5 tables in all, but I need to enter all Employee details in one table. Surely its not so hard to ensure Title and Gender are entered consistently?

I have been specifically asked to create these two fields, Title and Gender in the Employee table and ensure consistency between them.

I can see how that would work, but I don't want a separate table for Title. I need to include both Title and Gender in the Employee table but ensure that they match up.

tbl_Employee pkEmployee_ID (autonumber) strTitle (4 char string) "Mr", "Mrs", "Miss" or "Ms" strGender (1 char string) "M" or "F" I need to ensure consistency between Title and Gender. What is the best way to do this? Validation rule? Thank you.