Hi, I'm a noivce at this, but, I was hoping someone could help. I'm trying to create a script or an action in which if I typed a "serial number" then it would automaticly bring up both a "product id" and drescription".

Also, I was wondering if I enter a certain text in a "field" how could I disable another "field" because the previous "field" was filled in.

Example: If someone had a tax exemption number then the tax "$" figure would become "0", but, if there was no tax exemption number than the tax "$" amount would have a "$" amount.

If you could help write or show me how to write the script for both problems, that would be very, very helpful.

I used to know how to use Filemaker before but, that was a long time ago and hoped someone could help out.

Thanks

Use lookups for first problem!

Use calculating field for second problem as this:

Tax_Rate=Case(Taxeable;0.2;0)

Hi photox, and Welcome to the Forum,

Your approach using serial numbers I don't believe is the best approach. Between you and I, I could never remember a number as well as drilling down through a manufacture's name, products, etc. My approach would be to use a Dynamic Value List, there are a few sample files, and plenty of threads in the Value List Topic Area on this.

The attached file is an approach to the Tax Exempt problem.

TaxExempt_Yes_No.fp5.zip