Hope I'm not asking something already answered, I've looked but couldn't find. And apologies if I'm asking it poorly :).

I am trying to customize an insurance agency crm. 

I have a CLIENT module that has the client's MONTHLY PREMIUM manually entered, and a CARRIER (selected from the CARRIER module using a lookup when entering the client's info).

Each Carrier in the CARRIER module has a "Number of months advanced" field and a "Commission Percentage" field. 

I want to perform a calculation on the CLIENT module, that uses data from the CARRIER module. 

The field would be called AdvancedCommission and it would be ((CLIENT:MonthlyPremium * (CARRIER:CommissionPercentage)*(CARRIER:Number of months advanced)).

Is it possible to use the lookup to pull the two pieces of information required from each CARRIER when it's done from the CLIENT module's "AdvancedCommission" field?

Thanks!

Joe