Prev: new messenger
Next: Continued frustration with relationships and queries
From: H on 9 Mar 2010 11:24
I am would like to create a form that displays data based on what the
user selects.

Ex...I have a table the has customers and their orders. Each customer
can have more than on order.

I would like to set up a form that a user can select/lookup a customer
and all their orders appear in a list format. I would also like the
user to be able to add in new orders from the form.

Is this possible?
From: Duane Hookom on 9 Mar 2010 21:27
You can use a main form with the combo box bound to your customer primary
key and then a subform of orders using the customer primary key as the link
master/child properties.

--
Duane Hookom
MS Access MVP

"H" <hendrix.paul(a)gmail.com> wrote in message
news:eb40f5b4-f034-4134-a049-a05b34f0f42a(a)t23g2000yqt.googlegroups.com...
> I am would like to create a form that displays data based on what the
> user selects.
>
> Ex...I have a table the has customers and their orders. Each customer
> can have more than on order.
>
> I would like to set up a form that a user can select/lookup a customer
> and all their orders appear in a list format. I would also like the
> user to be able to add in new orders from the form.
>
> Is this possible?

 | 
Pages: 1
Prev: new messenger
Next: Continued frustration with relationships and queries