validation rules across fields

[lscheer]

I think that I need to use a table or record-level validation, but I can't seem to get it to work:

I have two fields: Tribe and Organization. Any one person cannot have data in both fields, therefore I want to set it up so that the user can't enter data in both fields???

 

[RV]

You'll need to define validation rules on FORM level (Design, Data, Validation Rule).

Validation rule for your first TextBox:

Forms!YourFormName!NameOfSecondTextBox Is Null

Validation rule for your second TextBox:

Forms!YourFormName!NameOfFirstTextox Is Null

But.....
why don't you use a ListBox containing the values Tribe and Organization and only one textbox.
A user selects from the listbox and then enters whatever wanted in the textbox.
You don't need validation rules....

Greetings,

RV