Check Box Dependency in Table

[2tMonte]

I have a table and am trying to make the True/False value of a check box (DTSAppointmentOnFile) dependent on whether there is anything attached in an attachment box (DTSAppointment). The idea is that if DTSAppointment has an attachment, then the DTSAppointmentOnFile would be checked (yes,true,-1). If not, then the check would remain unchecked (default value of Null,0).

How is this accomplished within the table?



Once this is accomplished with in the table, the results will filter down to reports right?

Thank you.

[alansidman]

Have you considered an update query?

http://www.databasedev.co.uk/update_query.html

[2tMonte]

That worked like a charm...thank you for your time and assistance.