+ Drop down in a table

[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?

 

[Douglas J Steele]

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.

 

[Guest]

I have a form and a subform.
--
Ronnie

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.

 

[John Vinson]

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?

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]

 

[Van T. Dinh]

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.