Case Question

[Dezza12]

I am trying to write a script that will automatically enter the county name in the "County" Field, when I enter a zip code in the "zip code" field.

There are about 460 or so zip codes, and 32 counties. I have tried to use Case, but after I get past a certain number (not exactly sure how many), I get an error that says "There are too many separators in this function",

Any suggestions?

Thank you!

[Fitch]

"...too many separators..." simply means you have an extra comma somewhere in your calculation. But why make it so hard on yourself? Just make a Counties file with 2 fields, zip and county, and use this file for a lookup from your main database. You wouldn't even need a script!

[Dezza12]

Hmm, the new file idea seems perfect, and I will probably try that, and I agree with what you say the "too many separators" error is telling me, but I only get the error after I continue to add portions to the case function, and then, the error always highlights back toward the beginning of the script where I have already test saved the calculation, and it highlights a part of the calculation where no error is visible. So I think in this case it has to do with too many entries in the case function, but I'm not sure.

[Fitch]

Not sure if this still applies:

FileMaker Pro 3.0, 4.0, 4.1

There is a maximum of 168 nests allowed in a single IF or CASE statement.

In any case (haha), you'd be insane to do this as a calculation when a lookup file is SOOOO much easier. It's also far easier to maintain, although I don't suppose counties change often. But new zip codes do come along now and then, and it's a snap to add a new record to a counties/zips database. In fact, I bet you could probably find one already done if you poke around a little. Sorry I don't have time right now to search.

[RussBaker]

DEFINITELY go the lookup route. Its also much easier when you need to update your zip code database. In the land of Oz, Australia Post has a website from which you can download all the postcodes so its easy to keep up-to-date. I assume there would be something similar over your way.

Russ Baker