Newbies photox Posted June 1, 2005 Newbies Posted June 1, 2005 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
aaa Posted June 1, 2005 Posted June 1, 2005 Use lookups for first problem! Use calculating field for second problem as this: Tax_Rate=Case(Taxeable;0.2;0)
Lee Smith Posted June 1, 2005 Posted June 1, 2005 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
Recommended Posts
This topic is 7205 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now