I have 3 tables in my data model that contain substantially the same data. Each of the three tables represents a subset of the same information dealing with timeslips entries.
Table 1 contains timeslip entries in colums designated: UniqueID, date-of-service, Timekeeper, Time Worked, etc. (Some of these columns are unique to Table 1 and are not contained in Tables 2 and 3.)
Table 2 contains entries from the same timeslip with many columns identical to those in Table 1 (including UniqueID, which is common to all three tables), but Table 2 also contains columns that are not identical to columns in Tables 1 or 3, e.g., : billing status, bill value, etc.
Table 3 again contains entries from the same timeslip as Tables 1 and 2 with many columns that are indentical to those in Tables 1 and 2, but also contains unique columns that are not identical to those in either Tables 1 or 2, e.g., Work Description Text.
I have tried appending these 3 tables into a new table, but the new table now contains 3 rows for each timeslip and I am lost as to how to combine the rows based on the UniqueID so that I am left with only 1 row per timeslip.
Advice greatly appreciated.
