I have a table that features unique rows of data. This table is basically a list of dependents listed under an employee. To export this into a flat file, the dependents need to be changed from being listed below the employee to being listed across the employee's record in a subsequent table. I've already created the subsequent table that provides enough space for 12 unique dependents. I'm trying to figure out the best way of updating the table with all the dependents that fall within the criteria of an expression.
ID # Dependent ID#
1a 2a 3a 4a
I've created an update query that updates the appropriate columns for the first dependent; however, I feel like this might be a very cumbersome process of doing it, i.e. with 12 separate update queries. Does anyone have any suggestions?