Dear All,
I have a Master Table and a Detail Table. I would like to achieve something like this shown below under the LIST page of the Master table.
In the table above, where it says "Booker's Detail", the data is from the Master Table and where it says "Delegate Details", the data is from the Detail Table.
As you can see, I have created a View that joins the Master and Detail together. The output I got is as shown above but I only want one row of the Master to be shown. Now I have 2 identical rows because I have 2 records in my detail table. How do I fix this?
I have tried out the Master Detail relationship base on the example given but I can not achieve what I want to achieve like in the picture. Each time I add a new Delegate, I want to come back to this list page and allow the user to edit either the booker's or delegate's information.
Any insight as to how I can resolve this will be much appreciated. Again thank you in advance for all the help rendered.
Regards,
Danny.