I'm trying to automate with a scipted button in FM so that I get the creation of a new record in a related table/layout and I'd like to have the new record get the job number from the originating table/layout.

What's the best way to accomplish this in a script? I'm trying to copy the job number field in the originating record and then pasting in the the job number field in the related record, but it isn't working. Any suggestions?

Thanks!

Jana

Try using set field, maybe through another relationship or by using a global field.

I think that the fields have to be on the layout for the copy and paste commands to work.

Make sure you can see ALL the fields on the same layout (or in a portal) for copy / paste to work. Then switch layouts.(I sometimes use a field with white text specified on a white background to paste into so the user is unaware of the 'paste' before switching layouts.)

Or use a freeze window step to switch layouts to paste and then return. (I think this works.)

Or use a global to hold and switch layouts.

This is not really how I use globals now that there are so many more options in FMP7.

I'll bet there could be or has been a lively discussion here among the 'gurus' about speed and viability of the various options. Once you have several tens of thousands of records speed can become a real issue.