field rule for if a field is empty or not

field rule for if a field is empty or not

I'm setting up a DB for keeping track of product photos. One of the fields is "Date received", meaning the date we received a photograph back from the photographer.

I have another field which is to be a "Do we have the photo, Y/N".

This field will be used on another related DB so we can see if a photograph exists for a product or not.

I'd like to set the "Do we have the photo" field with a rule that says "If Date received is NOT blank", then set this field to Yes.

Is there a way to do something like that?