I need a little db help please

[Zanzibarjones]

I am making a simple db to track mining for an online game (no not WoW), another one.

Anyway, I have 2 tables.

tbl_Minerals: Which has these 2 fields:
MineralName (text field)
stoneValue: (currency field)

So it looks like this:
tbl_Minerals:
MineralName stoneValue
Mineral1 $0.01
Mineral2 $0.02
Mineral3 $0.02
Mineral4 $0.05
etc for about 30 records.

tbl_Claims:
Longitude Latitude Elevation Depth stoneQty Mineral
100001 900001 421 123m 85 Mineral1
100011 900002 421 225m 15 Mineral3
100211 802130 123 425m 234 Mineral1

I would like a Form to allow me to input the data into my tbl_Claims.
So I have txt fields for Longitude,Latitude, Elevation, Depth, stoneQty. I can manually enter the data into those fields fine. But when it comes to Mineral, I want the form to show me a list box of the data from tbl_Minerals, and only show the field MineralName, so I can choose one of them, and it ads that mineral to the text field in tbl_Claims.Mineral.

Is this done through a ComboBox with a Controlsource that points to a query that gives me that list and puts it into ascending order?

 

[r.harrison]

Hi,

Is this roughly what you wanted?

 

[Zanzibarjones]

Roughly, yes. But I do not want a pick list like you have there on the right. I would rather use a dropdown list that is populated from the minerals table.
And then a calculation on the form that calculates the mineral cost times the number of rocks found in that claim.

 

[r.harrison]

More like this?

 

[Zanzibarjones]

OMG yes, that's IT!!!
I am going to look over this to see how you did it...