I dont know if this can be done.. Im using Fm8 Advanced

I have a file with 1500 records.. For simplicity..

Carrier_rates file. I have Carier Code Field which is a number

Specialty code field which is a number

Then I have another 6 fields

A_limit

B_Limit

C_limit

Then

A_Rate

B_Rate

C_Rate

From another file called access_rates with a relationship I can get to the correct record based on the carrier code and specialty code but I need to choose the rate (a_rate,b_rate or c_rate) based on the Limit (a_limit,b_limit or c_limit) that is in a dropdown box in the access rates file. Is this possible..

Thanks for any help with this

Stu

Hi Stu,

Not sure when you posted but if you have a tricky problem, how can I not respond, being 'Tricky' on the list, hey?

Uhm, I am unsure I understand you correctly, but it sounds to me that you are looking for a conditional value list. A list, that shows values on the basis of a relationship. So, if you would enter a limit, the rates shown in the list would only show those that apply to the carriers with that limit. Is my assumption correct?