Just to let you know I only have Access 97 to play with and do not have access to the templates so i can't even play around with them.
I am trying to create a database which will have:
Contact details within that client (could be more than one)
Functions that can be invited to
RSVPs to the functions
I have started this already with a one to many relationship and a contact table/sub form within the client table/form.
CLIENT TABLE FIELDS
CONTACT TABLE FIELDS
We have a couple of functions through out the year which the contacts may or may not be invited to: Xmas Party and Golf Day.
Some of the contacts will be invited to both and others just to one.
We need to keep a track of RSVPs when they come in
i.e. if they have replied and whether or not they are coming
if they haven't replied at all so this can be followed up.
If i create an Entertainment table with a list of all the functions. How and where do I link/add this table to the other information?
I thought about having an RSVP table
If there is not tick in either the yes or no, then it would be assumed that we have not had a reply. But again, how do i link with the contact info?
It is probably quite simple but i can't get my head around it.
thanks in advance for your help