Child records as inputs in form
Hello,
I have three tables.
Table 1: Funds. Key field is an alphanumeric ID.
Table 2: Categories: Key field is an alphanumeric ID.
The Categories:Funds relationship is 1 to many. A category can have dozens of related funds.
Table 3: Proposals. Key field is recordID.
Users submit proposals via a form in table 3. Within a given proposal (form), the user identifies at least one or many funds - each of which is its own "related fund" record picker.
I'd like to give users a 'shortcut', i.e. I'd like them to be able to identify within the form a Category and have all the Funds of that category populate in the form - not as a related records report, but rather have each Fund record picker populate with a different fund of that category.
Is this doable?
Thanks in advance.
I have three tables.
Table 1: Funds. Key field is an alphanumeric ID.
Table 2: Categories: Key field is an alphanumeric ID.
The Categories:Funds relationship is 1 to many. A category can have dozens of related funds.
Table 3: Proposals. Key field is recordID.
Users submit proposals via a form in table 3. Within a given proposal (form), the user identifies at least one or many funds - each of which is its own "related fund" record picker.
I'd like to give users a 'shortcut', i.e. I'd like them to be able to identify within the form a Category and have all the Funds of that category populate in the form - not as a related records report, but rather have each Fund record picker populate with a different fund of that category.
Is this doable?
Thanks in advance.
