T
tomrector
Access 2002 XP SP2
304 records, 22 fields table 1
304 records, 16 fields table 2
linked on MemberID (text, 6C)
I am looking for suggestions on the best way to do something.
I have two tables
In the first table I have a yes/no field (bill_this_cycle)
In the second table I have 12 yes/no fields (months)
If any one or more of the 12 yes/no in the second table are checked
(or -1) I want to have (or set) the yes/no in the first table to 0 or
no.This will be a once a month recuring process.
The form for the 12 yes/no, is a subform that is in the main form for
the first table with the single yes/no.
Any suggestions or direction is truly appreciated.
304 records, 22 fields table 1
304 records, 16 fields table 2
linked on MemberID (text, 6C)
I am looking for suggestions on the best way to do something.
I have two tables
In the first table I have a yes/no field (bill_this_cycle)
In the second table I have 12 yes/no fields (months)
If any one or more of the 12 yes/no in the second table are checked
(or -1) I want to have (or set) the yes/no in the first table to 0 or
no.This will be a once a month recuring process.
The form for the 12 yes/no, is a subform that is in the main form for
the first table with the single yes/no.
Any suggestions or direction is truly appreciated.