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.
you are correct - I am booking a tour in which may have 1 to whatever number of participants - So the idea is to create a participant list for the booking where of course the actual client is also a participant
So I have a participant table and a booking table and I can add participants to the booking through a portal
Now the client is related to the booking number - So what I am trying to do is to relate the participant to the client and to the booking - The purpose is that next time I have a booking with the same client and I need to add participants I do not have to look at all the participants in the database but only to those related to the client
The only way I see this hapening is by first relating the participants to the client and then to the booking and this is too time consuming - I need a solution that allows me to do both allocations in one screen??
The extra info helps me picture the issue.
I think you're on the right track. I'd create a Client table and relate it to a participants table. To book a tour, you'd create one client record with 1 to however many related records in your participant table to list each individual.
I don't see why you can't do this all on one screen. Keep in mind that you can put data from more than one table into the same portal row if your relationships permit it. Also, you could have more than one portal on your screen. One portal could list all your booked "clients" and a second portal could list all the participant records for the current client in your Client portal. (You'd have to set up some scripting for that.)