talkinggoat
Member
I have two lists, one is a master, the other a child. The master holds the records for the individual being served. The child holds the records the operator who will be serving. In order to associate the two, I need an inner join, which I think I know how to do.
Here is what I haven't really been able to figure out:
The master and operator records are joined, on the same form, so when the operator record is written, it needs to index the master record (id), so the join knows how to associate them. For instance, if we're working with ticket #4 (which is the primary key in the master record) and operator Bob is assigned, there needs to be an association with ticket #4 in the Operators list. How do I tell Fabrik to stick that PK into the Operators list? Is this going to be a script or is it already available in the Fabrik settings?
Thank you.
Here is what I haven't really been able to figure out:
The master and operator records are joined, on the same form, so when the operator record is written, it needs to index the master record (id), so the join knows how to associate them. For instance, if we're working with ticket #4 (which is the primary key in the master record) and operator Bob is assigned, there needs to be an association with ticket #4 in the Operators list. How do I tell Fabrik to stick that PK into the Operators list? Is this going to be a script or is it already available in the Fabrik settings?
Thank you.