[Access VBA Central] De Normalizing a Parent Child Table in Export

 

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.

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 1

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___