Help with Multiple entries

[kevinscomp]

I am looking for a method to enter the same item multiple times by only performing one entry and I am having "writers block" on how or if it can be done.



I have a club i belong to that i have created a database to keep track of member info and its evolved to keeping track of year dues as well. I have a form called Member Personal info with all their personal info on separate records, within each record is several tab pages and one of the pages consist of Dues Info. The dues info page has their member #, current dues year, dues amount, etc. in a datasheet form. On a different tab there is a drop down menu with a Yes or No choice for does this member pay dues.

What i am looking to do is have a method to click either in a dialog box or something similar that will allow me to "invoice" each of the 110 dues paying members by have the year, the yearly dues, etc all into the datasheet this way i just enter the amount collected. When i run a report for the dues year it would have the dues amount for each member enter this way and i can tell who needs to still pays dues for the current year.


Any help is greatly appreciated.

Thanks
Kevin

[June7]

Sounds like you need to run an INSERT SELECT sql action to create the invoice records based on membership info.

You are recording the amount collected in the invoice record? What do you do if they make partial or excessive payment? Receipts should be separate transaction records.