Thank you for the reply. I wasn’t sure if there was an easy way to do this with a lookup or rollup field.
The title insurance is based on a cost per thousand. That would be an easy calculation, but the cost per thousand changes as the loan amount goes up. It is bracketed as follows:
Loan Amount:
1001 - 50,000 = $3.15 per thousand
50,001 - 100,000 = $2.50 per thousand
100,0001 - 200,000 = $2.20 per thousand
and so on.
There is also a minimum starting amount that gets added to the per thousand calculation. It complicates things further as the cost of say a $150,000 loan is determined by taking the first 50,000 at 3.15/thousand, and the next 50k at 2.50/thousand, and then the final 50k at 2.20/thousand.
My first thought was just to add a table with everything loan amount and put the associated fee next to that loan amount. If there was a way to cross-reference the Loan Amount field in Table A, with the same Loan Amount figure and Table B (and have it pull over the associated fee), I thought that would be an easy enough solution. But I can’t figure that out. I will probably just use a formula instead. I’m no math wizard so it takes me some extra time to figure it out.