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

inner join problem

imrosie
100+
P: 222
Hello,

Here's my situation.The main form built on query of 2 tables,customers and orders. You can locate a customer through the unbound combo box built on row query (custid, fname, lname). The main form filters by customerid and it's supporting query works on an inner join:

Expand|Select|Wrap|Line Numbers
  1. FROM Customers INNER JOIN Orders ON Customers.CustomerID=Orders.CustomerID;
currently there are no orders....(my db is new)....I've only added dummy customers to test out.

when I attempt to select a name from the control....the cursor runs past the name to the next control. so I tried changing the inner join to a left join (for customer table)....same thing happens.

My row query works great in my old database, so it can't be a problem there.....I really need to have these tables joined because of the 'order details' (in subform) that ties them together...

How can I over come this short of making up a ton of dummy orders? thanks

Rosie
Aug 12 '07 #1
Share this Question
Share on Google+
2 Replies


ADezii
Expert 5K+
P: 8,669
Hello,

Here's my situation.The main form built on query of 2 tables,customers and orders. You can locate a customer through the unbound combo box built on row query (custid, fname, lname). The main form filters by customerid and it's supporting query works on an inner join:

Expand|Select|Wrap|Line Numbers
  1. FROM Customers INNER JOIN Orders ON Customers.CustomerID=Orders.CustomerID;
currently there are no orders....(my db is new)....I've only added dummy customers to test out.

when I attempt to select a name from the control....the cursor runs past the name to the next control. so I tried changing the inner join to a left join (for customer table)....same thing happens.

My row query works great in my old database, so it can't be a problem there.....I really need to have these tables joined because of the 'order details' (in subform) that ties them together...

How can I over come this short of making up a ton of dummy orders? thanks

Rosie
  1. Open the Northwind Sample Database via: Help ==> Sample Databases ==> Northwind Sample Database.
  2. Create a New Query with the Customers and Orders Tables which is exactly the situation you currently describe.
  3. Do all you experimenting on this Sample Query.
Aug 12 '07 #2

imrosie
100+
P: 222
  1. Open the Northwind Sample Database via: Help ==> Sample Databases ==> Northwind Sample Database.
  2. Create a New Query with the Customers and Orders Tables which is exactly the situation you currently describe.
  3. Do all you experimenting on this Sample Query.
ADezii, that's wise.....really that was a wise suggestion. I don't know why I didn't think of it. Anyway, I'm so used to using the various revisions of the Order systems to experiment with, but you're right.

I'll give that a try now.
take care
Rosie
Aug 13 '07 #3

Post your reply

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