Is it possible for there to be multiple records in the Bookings table so that you would have to select one record in the portal to be able to see it's details?
Because the technique of selecting a record from a portal and showing it's detaisl can be seen in this demo file:
This however doesn't happen to be a join table, but the idea remains the same.
Pay attention especially to the relationship dialogue. And notice the second TO of the "Edition Selected"
If you can't figure it out, let me know I'll look into your situation in more detail.
The layout should show the Holiday details, the portal the related Bookings on that holiday so if I was writing this in SQL it would look something like:
select Client.firstName, Client.secondName, Client.email, Booking.invoicePaid, Booking.clientTravelPlan
from Client, Booking, Holiday
where Holiday.holidayId = [parameter]
and Holiday.holidayId = Booking.holiday
and Booking.client = Client.clientId;
I can get the portal to show related Booking or Client data, but I cannot see a way to join the 3 tables, and select the data I wish to display in the portal....
You would have this relationship series:
Holiday Table --[by HolidayID] -> Booking Table -- [by ClientID]-> Client Table
That will let you start from the Holiday Table and have a portal based on that Booking Table relationship (Table Occurance). From that Holiday record you will see a list of all the Bookings for that HolidayID. Picking up the Client Table information from that chained relationship (Table Occurance) will pick up all the Client details for that booking.
Hi, thanks for your reply. I had the relationship defined, I was just struggling to find the right way to show the records in the portal, which I have just figured out and it is pretty darn easy which is cool.