I'm having some troubles creating a record in a related file. I have a database that collects sales request info from the web. Thats works fine. I review that info manually within Filemaker and submit it to the real database via a button w/attached script.

The problem is submitting new records to the customer database. They are realated by CustNo relationship. I have a script set up to create a new record in the customer file, then use SET FIELD to copy data from the web database to the customer database. The new record is created, but the SET FIELDS are not working. I figure this is not working because the customer database is looking for a match in the web database which does not yet exist, since the record is freshly created.

As a workaround I have added copy/paste from the web database for the custno field into the customer database, then exit the record, and finally perform the SET FIELD for the rest of the info. That works, but seems very inelegant and possibly prone to breaking.

Is there a better way to create a record in a related file and populate it's fields?

Thanks,

Mark Durgee

Rather, than copy/paste, use a global field in either the main or related file. Any relationship will do, it doesn't matter with a global. Use Set Field into and out of the global.

Thank you, that worked great!

Mark Durgee