I am making an IWP site using filemaker. I currently have a form on the website (it's a form to enter lease information for a storage building.) This layout is tied to a table called newLeaseTemp. This table has a field called MailingZip, MailingCity, FeeTax, and FeeTotal.

I have another table called ColoradoTaxRates. This table has all of the tax rates for Colorado sorted by City and Zip Code. Basically, when the user enters a zip code and a city name on the form and clicks a "continue" button, I want it to auto populate the FeeTax and FeeTotal fields. I have a relationship set up between the tables for the city and zip code.

I just dont' understand what script commands I need to use to actually perform the search of ColoradoTaxRates, grab the data, and put it into the newLeaseTemp record.

I tried:

Perform Find[Restore]

(with the Action "Find Records" and the Criteria ColoradoTaxRates::Zip: [newLeaseTemp::MailingZip] but it doesn't work. The form isn't populated with anything and I can't select any of the edit fields on the form after it gets to this part of the script.

I am probably doing this is a totally wrong way, and I would really appreciate it if someone would point me in the right direction or give me an idea of the best way to do this.

Thanks in advance for the help.

John

Edited January 26, 200718 yr by Guest

Maybe you should look at using field lookups or relookup field contents.