Access Append/Update Query Issue

[JustSteve120]

I have an application, where, at the end of the month, I need a satellite application download data to a collecting database.

The data in the download is managed basically in three tables: a header table, a sub-header table (multiple events can occur within a header) and a detail table, so there is a one to a few many relationship.

Like this:

Audit --> Record --> Question

When I run the download, which is just an append query, the process is create multiple lines of the same detail data based on the number of sub-headers. So, if there were two Records of the same question set, the questions appear twice for each record.

Because this isn't what I wanted (obviously) I also split up the process -- first running an append query for the items in the detail table, then running an Update Query to add the material from the subhead table.

Same result.

Not sure what's going on. Anyone have a thought on how to get around this?

[jforbes]

Do you have the Query used to pull the records available?

I'm guessing that there is a one to many link between Audit and Question, but the Query is joining Record to Audit, then joining Question to Record, instead of joining Question to Audit.

[JustSteve120]

Thanks.

Yeah, I reconstructed the Query AGAIN from the starting point, and realized that I had a linking problem. Now works like a champ.

Whew.