The question at it’s simplest is whether LinkToForm can be used to set key pairs for a bridge table (reference table) within a form?
The scenario is I have a table ‘PermitList’ which has a column that stores keys to some self referenced rows, i.e. other permits that are linked with each other. When selecting a PermitList row I would like an action that opens up a form for my ‘Reports’ table and fills in the key pairs for the new report row and the relative permits into the bridge table.
To describe better what I want to accomplish. I have a permit with key 200, the column that stores all permit keys would for example say 100, 200, 300, and 400. When I click the action to start a new report, the form should ‘open’ and the ref column to the PermitList_Reports bridge table should be prefilled with the ‘New’ report key and each of the permit keys like NewReportKey-100, NewReportKey-200, etc.
I had initially tried doing this with LINKTOFORM(“FormName”, “VirtualColumnForReference”, LIST(Keys)) which does not seem to work. Is there some other way to get this accomplished in the form?
LinkedIn
Twitter
