Combo Box and table problem.

[Foster]

Another "simple" problem. It is ifyou know how to do it!
What I am trying to is have a form with say approx 20 drop down boxes on it. Each drop down box will list materials (from a table) that can be chosen. When the material is picked, the price needs to automatically appear. This bit I can do thanks to previous help!!. What it is that I need all the 20 materials and there prices that are chosen from the drop down menus to be stored in a separate table so reports can be run on them.


I have attached a demo database to hopefully show what I mean. I hope this makes sense.

 

[cominapart]

Foster, I did not download your database. Just from reading your post you should be able to create a query based on the table containing the items and their values. Then base the report on the query.

hth

 

[OneRandomStone]

Hmm...

Hey Foster,

Had a look at your tables to start with...it's a bit higgle de piggle de!

If you've only got Material Description and Price then i suggest doing it like this...

tblMaterials

(the ma before each field lets you recognize it as a field from the materials table)

maID (Autonumber)
maMaterial (Text)
maPrice (Currency)

Secondly, to you really need 20 drop down boxes? You could chose to use one drop down box and a command button the selected materials to a list box (lstSelected.AddItem = maMaterial)
then the user can see each selected material and its price...

Then you can use the list to create a report and or make the list perminent.

Just a suggestion,
Andy.