Simple Inventory update form

[gaccnovice]

First - I am a novice Access programmer so what I am trying to do may be the wrong approach therefore causing me grief trying to build it.



Problem: Trying to create a form to adjust quantities in an "Inventory Table"

Small home business whose products consist of container and contents. Can have 100's of contents and 10's of containers, but the combination of containers and contents that we are selling is much less than X*Y so so want to store only the products we are selling. Rather not have to create "user understandable" product keys. Trying to base the data on the unique combinations of container and content that we are selling.

Have three tables
"Contents" Table with multiple fields describing the contents. Primary Key is Content_Name
"Container" Table with multiple fields describing the container. Primary Key is Container_Name
"Inventory" Table has 4 columns, Auto-number Key, Lookup on Content_Name Field, Lookup on Container_Name, Quantity

Created a multiple field index on Content_Name and Container_Name in the Inventory table to ensure a combination of the two is unique in the table.

Trying to create a bound form to the Inventory table, with drop down list for the two lookup fields and allow the user to adjust the quantity field. Tried several things based on ideas from a book and the internet with no luck. Can't get the Quantity field (or the Key) for the combination of content and container to display for the record.

Seems simple, but I can't figure it out. Can someone point me in the right direction?

[June7]

Review http://allenbrowne.com/AppInventory.html

What you need to do with your current structure is find the existing Inventory record. Options are to use intrinsic Access search and filter tools or programming using UNBOUND controls to input search criteria to filter recordset or 'go to' record. Options for filtering:

1. http://www.datapigtechnologies.com/f...tomfilter.html

2. http://www.allenbrowne.com/ser-62.html