Relational lookup from one db to another
I have been trying to solve this for a few weeks and I am sure it is simple but I think I am missing the point, any help would be appreciated:
I have 2 db's one is for holding information about material, its purchase price and purchase size, this then does a simple calculation and works out the cost per sq cm.
The second db is for job's and the amount of material needed, I am trying to then take the amount of material needed, select from a drop down the material name (from the 1st db) this the takes the cost per sq cm from the first db and then calculates the cost of the total material used.
Can someone please point me in the right direction as this is driving me mad.