I have an app tracking our department's flight delays. Depending on origin/destination of the flight, it's assigned to a group at a specific base. I currently have my app set up to "assign" the delay to a specific user with a table to table relationship based on airport code. On the dashboard, reports pull data based on the current user being in the "assigned" field. More than one person in each base may be responsible for following up with these delays.
Is there a way to designate a user group, or multiple users (without making separate fields for each position) instead of one user to a record?
If I can offer any other information to advise on this, let me know! Thank you!