Continuous product/order form

[Jason Marshall]

Can anyone help me? I am trying to create a form in access that list's all
the products in our range and I would like have an order qty box attached so
that you enter a qty next to that product it saves back to the orders
table!? Any help would be greatly appreciated.

 

[Gary Miller]

Jason,

I will try and give you a hand.

First of all, in a normal order and order detail model, the
individual product in an order would get saved to the
OrderDetails table, not the master Order table. The Order
table should contain info such as OrderID, OrderDate,
Customer, etc... The OrderDetail table should hold the
individual productID, quantity, price, etc...

On your OrderDetail subform you can use the ComboBox wizard
to help you create a ComboBox to lookup your Products from
your Product table and then there are ways to set that up to
pull the Price out and poke it into the appropriate Price
field. The user would then put in the Quantity and you can
calculate the totals from these.

We can give you more help as you supply more details.

Gary Miller
Sisters, OR

 

[Arvin Meyer]

Can anyone help me? I am trying to create a form in access that list's all
the products in our range and I would like have an order qty box attached so
that you enter a qty next to that product it saves back to the orders
table!? Any help would be greatly appreciated.

In a normalized order details table, you would not show all your products,
just the ones that have been ordered. You could use unbound forms and a grid
control to show all the details, then write back to the tables with any
product whose value didn't equal 0. That's a lot of work and requires a
third party grid control, which may not work in future versions.

I suggest instead using a combo box with all the items listed, then do a
lookup for the price. There is an example of the type of order data entry in
the Northwind sample database that ships with Access.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access