Mandatory combination of fields

[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"

 

[Lynn Trapp]

No, there are no table level triggers that would make that possible. You can
do it in a data entry form, however.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

 

[Rick B]

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.

 

[Steve Schapel]

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.