I am almost in goal with my app now, just 1 last thing remaining before it works as it should.
I have a maintable (Inspection table) , with a ref to a subtable. The subtable is “Bedroom”, and contains all collums needed for bedroom.
My problem is that when i make an entry from inspections table “Bedroom 1” “Bedroom2” will show. But then when i make a new entry in inspections table, those two will still be there from the prevous entry. Anyone know how i can connect the Inspection entry together with those specific Bedroom Entries?
Here is praveens answer for a solution, but i havnt manage to get it to work properly… I used a Concentate formula with UniqueID and BedroomID (Bedroom 1, Bedroom 2, etc) But then when i put in bathroom 2, bathroom 1 no longer showed in the inspections table after.
“So try to get this to work first for just Inspections and Bedrooms. The Bedroom table should have a Ref column (let’s call it Inspection) to the Inspections table. Automatically, each time you add an Inspection, you’ll get the option to add multiple Bedrooms. Each Bedroom row must have a unique key value. I would recommend that you have an Enum column called BedroomId with values Bedroom1, Bedroom2, etc. Then add a composite key for the Bedrooms table that is CONCATENATE([BedroomId], “:”, [Inspection])”
Help is most appriciated Have a nice weekend!