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

Problem with Query with a relationship.....Please help

P: 2
I have a database with two tables I use for shipping information. One is for if I'm only shipping one item and the other is for a back page of a report for when I ship multiple items. If I'm shipping multiple items, I put SEE REVERSE in the single item block and then enter the rest in a subform linked to the multiple item table. I'm trying to generate a report that lists all items shipped using a tracking number, but when I create a query, I don't get what I need. The two tables have a relationship by the ID number, but when I call the two tables in a query and try to leave out the SEE REVERSE, all the records from the multiple tables are left out to. I understand why this happens, but can't figure out how to fix it. Please Help......Thank You.
Dec 6 '06 #1
Share this Question
Share on Google+
1 Reply


MMcCarthy
Expert Mod 10K+
P: 14,534
I have a database with two tables I use for shipping information. One is for if I'm only shipping one item and the other is for a back page of a report for when I ship multiple items. If I'm shipping multiple items, I put SEE REVERSE in the single item block and then enter the rest in a subform linked to the multiple item table. I'm trying to generate a report that lists all items shipped using a tracking number, but when I create a query, I don't get what I need. The two tables have a relationship by the ID number, but when I call the two tables in a query and try to leave out the SEE REVERSE, all the records from the multiple tables are left out to. I understand why this happens, but can't figure out how to fix it. Please Help......Thank You.
I'll need to see the structure of the tables involved with the tablenames, relevant field names and relationship to help. It might also be useful to post the existing query and explain the results you are getting and the results you want.

Mary
Dec 6 '06 #2

Post your reply

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