Title
Participants table
Post
I have a contact manager for my clients - Clients book tours from us - Tours can be for how many they wish on their party - I need to be able to add participants that are related to my clients and subsequently add the participants to the booking (Booking can have many tours) line items and then subsequently add them to each tour
The purpose of establishing the relation at the client level is that in the event the clients books with us again I will have a list of participants that have traveled with the client before and rather than asking the info again I can just choose who is traveling with him this time and relate them to then new booking and any tours inside the booking
Can you help on how to establish the relations?
Does a "client" represent an individual or a group?
It sounds like you have booking group tours and want a list of the people in each group (participants), but I could be misinterpreting.