Lookups?

[Glen62]

I am using fp5 in Australia.

I have a db for creating court documents. The documents contain various dollar amounts eg a court filing fee to commence a court claim and a court fee to get judgment.

The dollar amounts vary depending on the amount of the claim eg:

Range 1 = amount in dispute 0 -$1000 then fee is $100

Range 2 = amount in dispute 1000.01 -$2000 then fee is $150

Range 3 =amount in dispute 2000.01 -$3000 then fee is $200

I need:-

(a) The filing fee to be auto entered.

( The filing fee to be capable of change ie when the Court increases the fees

© The filing fee to remain unchanged in existing records when the Court does increase the fee.

I tried doing this with a calculation field but that means I can not change the amounts when the Court fees change.

I thought I needed to do this with a Lookup with the main db pulling this data from a Court fee db, but I can not work out how to get the main db to pull the right amount.

The amount of the disputed claim is imported in. So somehow I need that to tell the system what range the dispute is in ie range 1 , 2 or 3 and then depending on the range to lookup the correct court filing fee

Thanks for any tips.

[danjacoby]

Create a related file with the list of court fees. Have the actual fee (in the main file) be either an auto-entered amount, based on the relationship, or create a button to enter the correct amount once all the pertinent information is entered.

Don't use lookups; they're kludgy.