Create a query that pulls in all of the fields from both tables. When you run the query, you can export the results to excel.
--- In [email protected], "jhundleyj" <jhundl...@...> wrote: > > I have a parent and child table setup JobDecriptions and JobDescriptions > Items. > When I originally got the data it was in an Excel spreadsheet with columns for > Job Code and info ans then Task1 Task2 Task3 Task4 Task5 Ed1 Ed2 Ed3 Ed4 Ed5 > LIC1 LIC2 LIC3 LIC4 LIC5 . > > I was able to seperate the data into two tables one containing job code and > other information and then a second table listing each item (Task, Ed or Lic ) > and its type individually linked to the parent table in a one to many > relationaship. > > I have now been asked to recreate the original spreadsheet once or twice a > year > - What is the best way to merge these two tables back like they were with the > all the child records being in the individual columns in excel. >
