Duplicating Rows on purpose
I'm trying to figure out a way to create multiple entries on a grid with one entry from a form. I thought about creating "duplicate" tables that would simply receive the data from the form and then move it to the destination form. My concern is I would need to have the same number of tables to perform the move automation as I would like instances on the grid.
I basically have four venues and when an employee is hired into any of them, they're hired into all. I also considered writing an if statement that would change based on the venue chose but I'd still need a number of tables to duplicate the information. If anyone has any suggestions, I would appreciate it.