+ Drop down in a table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My datebase consists of customers and purchase orders. In the customers
table, when I click on the "+" next to a customer, it gives me a list of
purchase orders for every customer. I would like a list of only purchase
orders for the individual customer. How can I change this?
 
You really should build a form/subform combination, and link them to get
what you're looking for.

Tables aren't really intended to be used interactively.
 
I have a form and a subform.
--
Ronnie


Douglas J Steele said:
You really should build a form/subform combination, and link them to get
what you're looking for.

Tables aren't really intended to be used interactively.
Click to expand...
 
My datebase consists of customers and purchase orders. In the customers
table, when I click on the "+" next to a customer, it gives me a list of
purchase orders for every customer. I would like a list of only purchase
orders for the individual customer. How can I change this?
Click to expand...

By a) setting the relationship between your Customer table and
Purchase Order table to use the CustomerID, and b) by not using table
datasheets for anything other than debugging. Use a Form with a
subform instead - much more powerful, controllable and versatile!

John W. Vinson[MVP]
 
Have you specified appropriate LinkMasterFields and LinkChildFields for the
SubformControl?

It is likely you need to specify "CustID" from tblCustomer for the
LinkMasterFields and "frg_CustID" ("frg" stands for ForeignKey) from
tblOrder for the LinkChildFields.
 
Back
Top