Feature Request – Multiple Fields for a Join/ Link to Search

[Shane]

I remember doing this in MS Access where you could link / join more than one field from the parent to child table (form). In TFP it would open up a few very cool possibilities such as the ability to show/ edit/ create subsets of records.

So for example, if you link a Project Field AND a Client Field to a child Tasks Form, it would auto-populate the Client and Project fields in the tasks form if you added a record.

Similar in purpose, it would be cool to be able to use something like a “Link to” field to connect to a pre-created search. I know you can use Javascript to access Search records, but it would be easier for people to do it with a “Link to” field (or whatever it could be called). Clicking on the populated records would go to that set of (search result) records for editing. I feel adding records from this type of hypothetical field wouldn’t be possible because of the complexity of the user inputted search criteria.

Thanks for reading.

• This topic was modified 6 days, 9 hours ago by Shane.

[Brendan]

So if you have the same join field in two child forms and the one in the main parent form, then you can simply add a couple Join link to form fields to your form and Tap Forms should handle joining them at the same time as long as all 3 field values match.

Or do you mean compound join fields? If so you can simulate that with a Calculation or Script Field.

• This reply was modified 4 days, 10 hours ago by Brendan.

[Author]

Posts