Most Complex Controls work like portals, in that they use a relationship from the layout context through to the records to be displayed. There are, however, some limitations in the relationship:
- The relationship must be directly related to the layout table occurrence
- If you're expecting a control to create records, you must only use = in your relationship. Controls that don't create records can use all types of relationship (provided they are directly related to the layout table occurrence).
- You can ONLY use multiline keys on the LEFT side of the relationship (i.e., only on the layout table), except where explicitly mentioned in the BlackBoxes documentation.
BlackBoxes that support Multiline Keys on the RIGHT side of the relationship.
- The CalPack2 supports Multiline keys on the 'ResourceID' field for appointments, but this won't work for the original Calendar pack (You can use them only on the left-hand-side only there).
You can use multi-predicate relationships, including in combination with multiline keys according to the rules above.
Reactor Implementation Guide
Comments
Kevin (unauthenticated)
Dec 3, 2011
Will plugin work with the data separation model
Sam Sehnert
Jan 16, 2012
Kevin, Yes it will — you must define any table occurrences from the external file in the interface file. If your solution uses multiple files, it would be best practice to define each table and relationship used for Reactor in EVERY file (especially if your user might have multiple windows open from multiple different files).