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.
