Augment data following append query

Hi Karim

Ideally I'd add a "Assigned Team" field to my team members' source files to make it nice and simple.

However if you can't do that then It sounds like you'd need to add a reference column in the appended query such as FileRow

This would then give

File1Row1

File1Row2

File1Row3

File2Row1

File2Row2

File2Row3

You could then maintain a separate table that would be set up like this

Reference    Assigned to

File1Row1   Person A

File1Row2   Person A

File1Row3   Person B

File2Row1   Person B

File2Row2   Person C

File2Row3   Person D

Then merge this new table with the append table