I am trying to figure out an IF calculation that will enter the amount of tax I need to charge in a certain territory. I was thinking that I could something like:

IF Country (in thins case the US) = x then enter 0, and IF Country (Canada), and State = y,z (1 thru 9) then enter 7, and IF Country (Canada - maritimes), and State = y, z (10 thu 12) then enter 15

I am not sure how to script something like this in Filemaker, anyone out ther who can help me? Thanks...

You don't need to script it. A calculation field should be sufficient. Check out the Case statement.

Case(

quote:

---

Originally posted by Chuck:

You don't need to script it. A calculation field should be sufficient. Check out the Case statement...

---

Something that might be easier to maintain would be a small related file, from which you can simply lookup the information based on a Country-State relationship.

------------------

=-=-=-=-=-=-=-=-=-=-=-=-=

Kurt Knippel

Consultant

Database Resources

mailto:[email protected]

http://www.database-resources.com

=-=-=-=-=-=-=-=-=-=-=-=-=