Hi,

I'm trying to make a script that moves a record from one file to another. Records older than two weeks in File A will be moved to File B and deleted from A. I've tried to do this by making the two related by "record number", and then setting the various fields in File B. However, the delete script steps takes the record out of both files.

This seems strange as I believe have the relationship set up so that related records are not deleted through the master, and can only be created one way. The FM Help says to use the Exit Record script step to make sure related records aren't deleted, but I don't think this step exists?

Can anyone help point out what I'm doing wrong? Or suggest another way to move records?

Thanks in advance!

This seems strange as I believe have the relationship set up so that related records are not deleted through the master, and can only be created one way.

Did you check it? In your relationship graph, double-click the = between the TOs. Check the bottom section. Check that neither are checked on 'Delete Related Records...'

Exit Record/Request is now called Commit Record/Request in the Records section of Script Maker. Also be sure you are on the right layout when you delete your record in Table A. Go to Layout Setup and be sure it specifies 'show records from' Table A. And when you say they are related on 'record number' I assume you mean a unique ID and not FM's record number?

Also if you have multiple relationships, one of the other less obvious one may be causing the delete

Charles

Thanks for the help!

I inserted a "commit record" step, and made sure to go to the right layout. It works now. (I did mean unique ID and not FM's record number).