Help Please

[Berts76]

I have two columns in a table;

BLDG_ID
CELL_ID

If one is null, then the other cannot be.
Also, if one is not null, then the other must be.

How do I write that in the validation rule on the table itself.

Thanks much.

[maxamis4]

As of now I do not know of a way to do this. In Microsoft SQL server there are procedures and triggers that come to mind to stop this. But in access the only way i know to do data validation is through forms. Usually that involves some visual basic which is pretty simple.

Let me know if you need help

[ADezii]

I have two columns in a table;

BLDG_ID
CELL_ID

If one is null, then the other cannot be.
Also, if one is not null, then the other must be.

How do I write that in the validation rule on the table itself.

Thanks much.

Berts76 - you really taxed my brain on this one, but in the Table Properties Dialog under Validation Rule:

(IsNull([BLDG_ID]) And Not IsNull([CELL_ID])) Or (IsNull([CELL_ID]) And Not IsNull([BLDG_ID])) Or
(Not IsNull([BLDG_ID]) And IsNull([CELL_ID])) Or (Not IsNull([CELL_ID]) And IsNull([BLDG_ID]))

[maxamis4]

Learn something new everyday

[apartain]

I had to do it in the form. I set the BeforeUpdate event property of the form to the name of my macro.

I then created a macro with the following condition:

[Cell_ID] And [BLDG_ID] Is Not Null

and the action to MSG "Invalid Entry"

the next action (same condition) to CancelEvent.

Now when you use the form to add a new record, Microsoft Access runs the validation macro after you finish entering the new record, but before it saves the record in the table. If the condition in the macro is met, Access displays the appropriate message and doesn't save the record in the table. It will take you back to the record to make a change.

BTW, I got this information directly from the help files under Validation Rules, About Validating Data Programatically.