Linking (a child) to two (parent) forms

[Johanna]

Hello,

this might probably have been asked before, sorry, but I couldn’t find a thread referring to my problem.

Is it possible to link a (child) form to two different (parent) forms? For example:

I have a db form for ‘objects’ (child) that is linked to a db form ‘rooms’ as well as to another db form ‘categories’. In both cases I use the ‘one to many’ link type (one room -> many objects, one category -> many objects).
Now, when I have chosen a room in the rooms table of ‘objects’ child form and choose a category in categories table in the same record, the link to the room vanishes.

What am I missing?

Thanks
Johanna

[Brendan]

Hi Johanna,

You can do this as long as you’re using a Many to Many Link Type on your Link to Form field. It can’t be done with a one-to-many Link Type. The reason is that on a record, Tap Forms stores an ID that points to its parent record. Since there’s only one column in the database to hold this value, it can have only one parent.

Thanks,

Brendan

[Johanna]

Hi Brendan,

I see, thank you for your answer. :-) I’d tried it with the ‘many-to-many’ link type before, but it didn’t work then. Turned out, I had first to remove the checkmark that was giving the link back (I don’t have the english version, so I don’t know a better term for it) to the child record in the link-field definition. When I checked it afterward again the table style changed to a ‘many-to-many’ table and everything worked fine.

Thanks
Johanna

[Author]

Posts