L
laskowv
I want to be able to "post dues" in a membership database for an entire
chapter at once and write a "transaction" record for each payment. The dues
amount is static at $15. Sticking with a simple design, let say I have 2
tables, MEMBERS (MemberID PK) and PAYMENTS (PaymentID PK with MemberID FK).
PAYMENTS also has PaymentDt and PaymentAmt as fields. MEMBERS has checkbox
field for "Paid".
Lets say I have 10 members. I would like to have a continous form list all
10 members; a checkbox to select all as "paid"; and then have a command
button "post the payments" by writing all 10 records to the PAYMENTS table.
I would also like the "Paid"checkbox field in the MEMBERS table to reflect
"true".
I know I would need an "update query" to post to the MEMBERS table the
checkbox value; but it's writing all 10 records that I'm not sure about.
From reading other postings I'm not sure if I need an "append" query, and
"Insert Record" command, or a "New Record" command.
Your assistance would be greatly appreciated.
chapter at once and write a "transaction" record for each payment. The dues
amount is static at $15. Sticking with a simple design, let say I have 2
tables, MEMBERS (MemberID PK) and PAYMENTS (PaymentID PK with MemberID FK).
PAYMENTS also has PaymentDt and PaymentAmt as fields. MEMBERS has checkbox
field for "Paid".
Lets say I have 10 members. I would like to have a continous form list all
10 members; a checkbox to select all as "paid"; and then have a command
button "post the payments" by writing all 10 records to the PAYMENTS table.
I would also like the "Paid"checkbox field in the MEMBERS table to reflect
"true".
I know I would need an "update query" to post to the MEMBERS table the
checkbox value; but it's writing all 10 records that I'm not sure about.
From reading other postings I'm not sure if I need an "append" query, and
"Insert Record" command, or a "New Record" command.
Your assistance would be greatly appreciated.