Multiple data entry question

[Appeal]

Hi,

I am trying to improve usability of a inventory database I have created. I have a table for individual components and a table for inventory transactions. Using a query I have then taken from the components table only the components that are used for a certain product range. I then create a form based on this query for each product range displaying all the components in a list. I would like to add a column at the end of the table so that the the end user can simply fill in the quantities they want of each component to take out of stock and then this will automatically fill in on the inventory transactions table. Currently the user has to open a form for each individual component with the inventory transactions for that item in a subform.

I have attempted to do this using a unbound field and using it in an append query. When I do this though if I enter a value into the unbound field it automatically fills in all the rows bellow it with the same value for every component. Could anyone help me with this problem?

Many thanks.

[aytee111]

What are the users selecting at first, is it the product range? Do they want to be able to see all components at one time in a certain product range?

You can accomplish this by means of a combo box for the product range and then a subform which displays all the components bound to the component table. Then they can enter values directly into the table via the subform.

[Appeal]

Hi,

The user selects the product range from the home navigation screen this then generates the list of components. As the components can be used for multiple products I created a column for each product range with a tick box in the product table. I then created a query for each product and set up a multiple item form for the query which generates for when the user presses the button for that product on the navigation home page. In terms of my inventory transaction table it is set up as shown below:

[TransactionID] [ComponentID] [TransactionDate] [TransactionType] [StockIn] [StockOut]

I have my list form set out under the following headings:

[ComponentID] [Description] [StockAvailable] [QuantityRequired]

The StockAvailable column is generated from the StockIn and StockOut columns of the inventory transaction table. The QuantityRequired column is the unbound box which I would like to fill in the StockOut column when the user types in the amount of stock they require for each item then click an allocate button to put in the Transactions table.

[aytee111]

Can you attach this portion of your database?