Linking Multiple records

Hello friends,


I want to link multiple records in access database.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.

Can anyone help me with this?

You can use this code it should work:

Please Login or Register  to view this content.