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

I could swear I've done this before, but for some reason its not working. I want a script to create a new record in a different database from data in a current database record. I thought You just used "set field" or insert calculated value and it automatically created a new record with that data in the target field. For whatever reason its not working.

I am running FM Server 7 Advanced and FMP 7 Developer. I'm having trouble updating the files even though they are both open on the Developer machine.

Ideas? Thanks!

--

Chevell :

If you have your relationship setup so that it is 'Allow to create new records", then when you enter related data for a record via a portal etc, it will create a new record.

Otherwise, you can create a new record in another file by creating running an external new record script in the other database.

Try the New Record script right before the Set Field. Also make sure to Save the record.

David