I've got 2 files I've created a relationship between. The main file has one look-up field, a phone number which is auto-entered when a name is entered in the main file. I would like to add a look-up for an e-mail address as well, but this has not been an existing field.

I've added a new e-mail field (text) to both files, created the look-up, but I can only get the e-mail field to populate in my main file if I enter the name. So, the problem, friends, is that existing records don't execute the auto-enter for the new field. How do I make this work globally/automatically without going through each record and updating the names one at a time? (I hope that made sense)

FileMaker Version: 6

Platform: Windows XP

Lookups are designed to update only when their key field is changed or a Relookup is performed. So run a Relookup in your name field, and you will update all found records.

Note: auto-enter calculations perform similarly, except they are only entered once, when a record is created. If you add an auto-enter after records have already been created, then you must perform a Replace on them with the auto-entry calculation.

Thanks for the tip Queue,

I'm a relatively new user (intermediate I guess). How do I perform a Relookup? I assume its a Script calculation, but I can only write basic stuff at the moment and I don't yet fully understand FM syntax yet. Could you maybe give me a little more specific direction (calculation commands, etc.)

Thank you much!

Well, it sounds as if you're only wanting to relookup the existing records for the new field you added. To do that you'd first put your cursor in the name field, then select Relookup from the Records menu.

To script it, you'd use a Go to Layout [layout containing the name field], then Relookup, click the Perform without dialog checkbox, and Specify the name field.

That did it!! Thank you so much. (you can't see me, but I'm graciously bowing)