I was going to ask a question cause I was stuck. But in the end I managed myself. So this is just to share the dev-process with whome ever is interested.
I have this database with Contracts. Many Pictures can belong to Contracts. Also many Elongations can belong to Contracts. And these Elongations can also have some pictures of their own.
So I set it up like this:
- Table with Contracts. With an ID
- Table with Elongations. With an ID
- Table with Pictures. With an ID and a ContractFID and a ElongationFID
It looks like this. (Imagine these are layouts with portals in them).
Contracts and thier Pictures I had already going. So far so good. But then I tried to drag the third relationship from Pictures::ElongationFID to Elongations::ID and FM reported No can do. And it suggested to drag to same field in a second TO of Elongations instread. I did that.
But the trouble was, that when I'm in the Elongations layout and I added a new related picture, it wouldn't relate.
But then I noticed that in the Picture layout, if I pull in a field from Elongations 2nd TO, it would show. So then I was beginning to get the idea.
Then I deceided to not have 2 elongations TOs, but rather 2 Pictures TOs. Now I have this and it works.
I guess this is just one of those basic-relational-DB lessons.
My next challenge is to make buttons/scripts that allow the user to "move" a picture from and Elongation to a particular contract, but that's doable cause they all have their ID's and it's a matter of emptying and filling the right Forreign IDs.