Mandatory combination of fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible at table design level to make it mandatory if one field is
populated that another field is populated?

For instance, I have a field called "deadfilenumber". If it is populated, I
want the user to be forced to populate two other fields called
"filesentdeadby" and "filesentbydate"
 
You can do this in the FORM. In the table, you might be able to do some
sort of validation rule that includes an IF statement. I've never tried it.
I do this type of logic in the form.
 
Slymeat,

Go to the Design view of the table. Select Properties from the View
menu. In the Validation Rule property, enter this...
([deadfilenumber] Is Null) Or ([deadfilenumber] Is Not Null And
[filesentdeadby] Is Not Null And [filesentbydate] Is Not Null)
Use the Validation Text property to enter the message the user will see
if the validation fails. This test will be triggered whenever the
record is updated.
 
Back
Top