I have a contracts table with ContractName and ContractRate.
I have a lookup field the in the Potentials table to select ContractName and store with the Potential
I would like to have the ContractRate field pulled into the Potential so I can use it to calculate a total (Potential Amount X ContractRate).
Any ideas?