inner join problem

[imrosie]

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:

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

[ADezii]

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:

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.

[imrosie]

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