Using a field to define a field

[gibbsa]

I'm not sure if I would use scriptmaker for this, but hopefully you can help me. I want to use what is in one field to automatically enter text into another field. So, if the first field has "EXT-1" as the entered text, I want it to put "Aisles, stairwells, and exits" in the next field. In other words, can I have Filemaker read what is in the first field and then put in the appropriate text in the next? Thanks!

[T-Square]

If the data that you auto-enter never changes (i.e., the "Aisles, stairwells, and exits" in your example is ALWAYS entered when EXT-1 is entered, and is not subsequently modified), then you might leave that second field as a calculation. Otherwise, set up the second field with an Auto-Enter calculation based on the first field. The calculation in these instances would be something like:

Case(Field1 = "EXT-1", "Aisles, stairwells, and exits", "EXT-2", "Barking Pumpkins")

Of course, if there are a lot of these, you might create a table to hold these and pull that data from there.

David