AnsweredAssumed Answered

selecting a record and extracting 2 fields from record for calculation

Question asked by user17311 on Jul 21, 2018
Latest reply on Jul 21, 2018 by philmodjunk

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.

Outcomes