Search results

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

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.

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...