List out items from a value list in a form

[wolfm]

Hello:


On the attached database, users are entering orders for a particular job, found in the "Shows" table. There can be many orders to one show, so I have it setup with a one-to-many relationship.
They use "Order Entry Form", to do so. This form has the "Shows" form on top, and an "Orders" subform.
So, users select from a list of menu items, contained in "Products" table, and add a quantity for each item, once they find the particular show.New Forecasting - Copy.zip

My question is: Can the subform list out all of the menu items without clicking on the drop down box, and the user just enters quantity for the appropriate item? I am thinking order entry would be quicker, with less clicking. Am I just missing a property setting for this field?

Thank you!

[June7]

This would require code that creates records. Then requery the Orders subform to display those records for further edit.

Which equipment items would you want to establish records for? The Products table has a lot of records and a variety of options.

[wolfm]

Idealy I would like all equipment items in "Products" to be displayed on the form, and then user puts the correct quantity next to it. But, yes I guess I would only want a record created if there is a quantity entered.

This would require code that creates records. Then requery the Orders subform to display those records for further edit.

Which equipment items would you want to establish records for? The Products table has a lot of records and a variety of options.

[June7]

The only alternative I can see is to have a quantity field in the Products table. Open form to that table, go down the list and enter quantity. Then code saves records to Orders table for each item that has quantity and associates those records with the current Show record. Then an UPDATE action clears the quantity field, ready for the next use.