Forum Discussion
I made a version of this, but it there may be a cleaner way to do it. Parent table "Employees" in your case Departments, has a formula-multi-select field that would populate in my case "crew members" your's would be department members. Then on my "timesheets" table when you select who is making the timesheet it has a multi-select lookup that pulls all the values in from that formula-multi-select in the parent. My problem is it does not show all the people selected, you have to open the dropdown and look to find out, but you can check or uncheck values in that lookup field before you save the record. Basically it gives you the default selection of multiple values for that field based on the lookup and then you can edit your choices before saving. Hope that helps?
What would the formula look like to display the members for the applicable department?
- MarkShnier__You4 months ago
Qrew Legend
It's not a formula, just a Report Link field type put in the form if you are using Legacy forms, or else on New Forms out a report of employees in the form, and select the report link field as a filter.