Query: UDO and UDV

Here is the scenario for my client:

I set up 4 UDTs for their freights (one for each location - Table A, Table B, Table C, Table D) which contains the number of Kilometers and the corresponding freight rate for the KM.

(Screen shot 1)

Now on another table where I need to set up per BP, I have columns:

Origin - A, B, C, or D (this corresponds to the location for each table)

To - (Linked to BP Address)

KM - manually input based on the actual distance of the BP address to the selected origin

Rate

Now I wanted to have an FMS where the rate will be automatically computed based on the KM input on the KM column, depending on the origin selected on the Origin column

(Example: If I selected A on Origin column and I input 25 KM, the rate will appear in the Rate column will be the rate on the Table A, If I selected B on Origin column and I input 25 KM, the rate will appear in the Rate column will be the rate on the Table B)

Anyone who can devise me an FMS for this? Thanks!!