Creating records in a different database

[chevell]

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

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 :

[mr_vodka]

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.

[T-Square]

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

David