Newby Link Price Fields

[edencorbin]

So I have a table "InventoryTracker", with one field lookup set to list (drop down) and the source is another table "inventory", field "Item". This works good and all the items that I enter in the "inventory" table are available from the "InventoryTracker" table. Both "inventory" and "InventoryTracker" have a field called price.

Heres what I want to have happen.
When I select a item from the drop down list menue in "InventoryTracker" it automatically fills in the "InventoryTracker" price based on the price from the "inventory" table (for the item with the same name, the one I just selected). This has to be fairly straitforward, I can do it in excell, but not acess.

Can anyone help a newby out?

 

[spectrolab]

I'm not 100% sure on this, but if you are using a list box, set the number of columns to 2, and include your item in the first one and the price in the second. If this list box is on a form and populates your table from there, it should work. But, you really need to work out whether you need both items in both tables, since this is duplicating data for no real reason. It would be better to use a query in this case. The Northwind db that comes with Access is probaly a good place to start looking as this has something very similar to what you are hoping to do.

 

[RV]

You need to create a form based on your Inventory Tracker table.
Put a list box that's based on your Inventory table.
See to it that the list box is a bound control (= is based on a column in your tracker table).

Access is not Excel.
You need to enter maintain your data via forms.

Do NOT use lookup columns, see for instance

http://www.access-programmers.co.uk/forums/showthread.php?t=52876

RV