Accepted Solutions
Ahh, yes, with the way you've got it set up you'd need a table just for "Main" locations, and you'd create a lookup field for the scenes. You can convert your "Decor" field into a linked field and select "Create a new table" and that should do it:
Sure, thanks for taking some time for my small problem.
If you look at the screenshot, you'll see three text fields. A "Main" location (A), a "sub-location" (B), a field calculated from both fields (A+B) and linked records from another table. A+B is the main field (and is unique for each record).
What I would like is to have, somewhere, a list of the main locations with the linked records of all their "sub-locations".
In this example, that would mean a way to show :
"Centre-ville" , and "9.15, 9.16, 9.17, 9.31, 9.44, 10.19, 11.13, 12.15"
"Route de campagne", and "11.11, 13.46".
I thought the "Main locations" should have a table of their own (I thought) but i am struggling to structure the thing correctly.
Ahh, yes, with the way you've got it set up you'd need a table just for "Main" locations, and you'd create a lookup field for the scenes. You can convert your "Decor" field into a linked field and select "Create a new table" and that should do it:
