Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Need a 1:M query to be updateable
34 views
Skip to first unread message
musicloverlch
Oct 25, 2012, 12:23:42 PM10/25/12
to
I have two tables:
Customers & Orders
In the Customers table, each customer is listed once (no duplicates)
In the Orders table, each customer can have multiple orders.
My client wants a screen listing all the orders that do not have a complete date. They want to include the customer name on that screen. If I add the Customers table, the query immediately becomes non-updateable.
My solution in the past was to add a dlookup field with the client name. That is so slow in Access 2010, so it isn't an option anymore.
How do I make the query updateable? (These 2 tables have a relationship).
Thanks,
Laura
Customers & Orders
In the Customers table, each customer is listed once (no duplicates)
In the Orders table, each customer can have multiple orders.
My client wants a screen listing all the orders that do not have a complete date. They want to include the customer name on that screen. If I add the Customers table, the query immediately becomes non-updateable.
My solution in the past was to add a dlookup field with the client name. That is so slow in Access 2010, so it isn't an option anymore.
How do I make the query updateable? (These 2 tables have a relationship).
Thanks,
Laura
Ron Paii
Oct 25, 2012, 1:28:27 PM10/25/12
to
"musicloverlch" <lho...@gmail.com> wrote in message
news:4808fe92-e20f-4813...@googlegroups.com...
Verify both tables have a index on the join columns. The customer table
should have a primary key.
SELECT Orders.*, Customers.Name FROM Customers INNER JOIN Orders ON
Customers.ID = Orders.ID WHERE is null Orders.completeDate;
David Hare-Scott
Oct 25, 2012, 5:24:26 PM10/25/12
to
D
0 new messages