The process that I am trying to program in the Access DB is as follows:



1. a participant signs up for a variety of activities
2. at the end of each month the activities which the participant went to are then put onto a single invoice with a single corresponding invoice#

I am trying to figure out how to take the three or four activities after it is all said and done and assign them a single invoice #. This process is backwards from the way I am used to doing it. I cannot create the invoice first and then add the activities just in case a participant only signs up for one activity and then cancels. That invoice# will them be unusable and I need all outoging invoices to not skip any numbers.

I hope this explaination was ok. Can anyone help me with this?