I want to set up a preference table where the user can select a preferred chemical from a related table.
Once the user selects the preferred chemical the preference table then extracts data from 2 different fields from the preferred chemical to use the data in a calculation used elsewhere. eg
Herbicide table has "Product name", "dosage rate", "cost per ml" fields plus others.
Using the product name how do select those two feilds and save them to the preference table,
or how can i get the fields from that record to use in a calculation.
As i am a newbie. links to instructions or something would be great. or a sample i can copy.