Hi Jason, hope you're well.
I'm just picking up on the project I spoke of before, it has developed further than expected and not quite sure how to structure it to work with Relational Tables. I wonder if you can offer any advice.
Essentially I'm building Insert and Update pages for products. A product can be assigned to a number of different Devices, and some of these Devices can be within different Categories. For example..
PRODUCT - Blue case - is compatible with DEVICE iPhone 5 and DEVICE iPhone 4 which are both within CATEGORY Mobile.
PRODUCT - Red case - is compatible with DEVICE iPhone 5 in CATEGORY Mobile and with DEVICE iPod Mini in CATEGORY Audio
I've planned four tables...
CATEGORY containing CATEGORY_ID and CATEGORY_NAME
DEVICE containing DEVICE_ID, DEVICE_NAME and CATEGORY_ID
PRODUCT containing PRODUCT_ID, PRODUCT_NAME and countless other details
ProductDevice containing ProductDeviceID, ProductDeviceProductID and ProductDeviceDeviceID
On my insert page, for the user to be able to select any DEVICE in any CATEGORY I created a number of RecordSets that are all populated by the DEVICE table, but each one filtered by a different CATEGORY ID. I then followed the online 'Blue Sky Music' tutorial by having checkboxes within a Repeating Selection populated by the first device RecordSet, and then duplicated for all the other device Recordsets. I've attached a screen grab so you can see how each one is housed in a tabbed panel.
The problem I've found is that because I've had to split the DEVICES across a number of Repeat Selections, when I reach the stage of inserting the MRT into the Insert page and specifically the Options Table Join panel it lists all the Repeat Selections separately when ideally I need to be able to select them all seeing as they are all populated by the same database table.
Do I need to structure the database differently or maybe the page to be able to work with the MRT? I had originally hoped that I could set up several MRTs on one page, but noticed in another forum post that this isn't possible.
I would be very grateful for any advice you can offer.
Many thanks in advance and kind regards