Form affects a table and then table affects different table

What I want to do is have a user submit a request form which goes to a manager. The manager then see’s it in their table and in that record, assigns the request to either a specific employee or to a group of employees with a certain role. So from the employees perspective they will have two tables, one with specific tasks for them and a general one where they can claim the task.

I can’t seem to wrap my head around how to pull off the multiple step process and the multiple outcome options.

Thanks in advanced for any help!

For anyone who stumbles upon this, I (and maybe you!) was thinking too hard. Instead of moving and duplicating data to multiple tables with multiple data sets, just use one data set and multiple tables with different rules on which kinds of records are shown, who can see what, and filter the info down that way. Thanks to Chem for helping me work through it!

Glad you got it sorted!

1 Like