Link to Form set Many-to-Many Dereference

I have the following scenario:

A table of PermitList with a many-to-many relation to MeterInspections via a bridge table called LaramieCoMeterInspections_Has_PermitList. In the detail view of PermitList I have a Derefence column with formula REF_ROWS("LaramieCoMeterInspections_Has_PermitList", "PermitList_fk"). From this inline view I have a โ€˜Addโ€™ button when clicked brings me to the relation view where the value of PermitList_fk is set to the id of the current PermitList row and the MeterInspection_fk field I can choose โ€˜Newโ€™ or an existing MeterInspection row. If choosing new then the MeterInspection new row will have the PermitList preset and I can continue entering the information for the MeterInspection.

I would like to use a custom action under PermitList that will accomplish this โ€˜step?โ€™ process and figured I could get this accomplished via โ€˜go to another view within this appโ€™ and using the following navigation LINKTOFORM("LaramieCoMeterInspections_Form", [Related LaramieCoMeterInspections_Has_PermitLists][PermitList_fk], [_THISROW]). Unfortunately this does not seem to work. Ideally I would like this kind of action both as the prominent action for a PermitList row but also would like this type of action to replace the default โ€˜Addโ€™ inline action under the Dereference to MeterInspections.

Can this be accomplished via a sequence of actions possibly or is there some other way to set up the Linktoform navigation to get this accomplished? @Steve Hoping maybe you have some insight on this since you seem very knowledgeable on Appsheet.

0 2 232
2 REPLIES 2
Top Labels in this Space