Connecting 2 datasets to allow user input on the child data

This is driving me mad, I’m not sure if it’s because my head is too deep in things at the minute, but it should be a simple task, I just can’t think on how to do it the right way!

I have a Dataset (Caravans) and want to have another dataset linked to this (CaravanFacilities). CaravanFacilities has Caravan as a Referenced Field and Facility as a Referenced Field which Links to another LU Dataset (Facilities).

I have users inserting Caravan Details (Description, Location, etc) and then I want them to be able to add/edit/delete the facilities for the Caravan they are editing . The Caravan page is a Dynamic Page, and ideally I’d like the user to be able to add multiple facilities on that same page. If that cannot be done, then it could link off to another page, but I want the Caravan selection to automatically be populated, so that it is only the Facility Lookup that they are adding.

I can get it to work so that the it displays all the picked options in a read-only style format using a table, but I want the user to be able to add additional records or amend/delete existing?
How is best to do this?

I have tried with a Repeater and Adding a Dropdown input on it, It links up in design, but doesn’t display the values?

If there is an easy step and tutorials for this, please just point me in the right direction. I’m normally fine with Database design and linking, but just cannot get this right? Is it because it is on a dynamic page?

Thanks
Dave

The following examples demonstrate how to use input elements in a Repeater , and how to add and remove Repeater entries: