Kim, you don't need to merge all the records from the three tables into one , just link them together. Looks like a relationship problem, as above.

Is there a field common to all three tables?