OK, I am a total newbie using Access, so this might be a really stupid question, but here goes:
I am trying to set up record-level validation in a table, to ensure that values in my MailingAddress field do not equal those in my PhysicalAddress field. (If someone's mailing address and physical address are the same, I want the user to leave the PhysicalAddress field blank. Only want to populate PhysicalAddress in cases where, for example, MailingAddress = "PO Box 123" and PhysicalAddress = "671 Main St")
The Access help information (using Access 2007) says you can enter field-level validation rules (which cannot reference other fields), and/or record-level validation rules (which can refer to multiple fields within a record). Entering a field-level rule seems simple enough, but how do I enter a record-level validation rule?!? The Help says to open the table in Design View, then click on the General tab and enter the rule. But whenever I open my table in Design View, one of the fields is ALWAYS selected!Thus, I am ALWAYS entering a field-level validation rule (and if I try to enter a rule like "[MailingAddress]<>[PhysicalAddress]" it gives me an error message when I try to save it!).
So, how do you enter a RECORD-level validation rule for a table?