By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,934 Members | 1,476 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,934 IT Pros & Developers. It's quick & easy.

Access Append/Update Query Issue

P: 7
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?
Feb 11 '15 #1
Share this Question
Share on Google+
2 Replies


jforbes
Expert 100+
P: 1,107
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.
Feb 11 '15 #2

P: 7
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.
Feb 11 '15 #3

Post your reply

Sign in to post your reply or Sign up for a free account.