I have a table tblPerUnitCost. There are 2 fields: PartNumber (text) and UnitCost (currency)
I have another table tblScrapTicket. There are two relevant fields: PartNumberID (Number) and UnitCost (currency).
I have a third table tblPartNumber with four fields: PartNumberID (autonumber), PartNumber (text), PartNumberDescription, ComponentID. Many of the part numbers are alpha-numeric.
I'm thinking I will need to do two lookups. The purpose for the first lookup is to match the PartNumberID I get from my frmScrapTicket control cboPartNumber against my table tblPartNumber and assign the PartNumber (which is text) to a variable.
The second lookup would be to use that variable to lookup the PartNumber from my tblPerUnitCost and assign the UnitCost for that part to my tblScrapTicket. The reason I do this is because unit prices change frequently.
I hope I've been clear and would greatly appreciate help in setting this up.
Start Free Trial
