I would like to have a script whereby:
1. Import records from Database A into Database B (relationship of records is established on import via a record id)
2. Delete related record in Database A
I tried the following (working in Database B):
Import Records [ "Database A" ; Add ]
Go to Related Record [ Show only related records ; From table: "Database A Table" ; External ; Using layout: "Database A layout" ; New window ]
This script imports the record from Database A but then deletes the imported record in Database B rather than the related record in Database A. So I then before the delete step I added:
Select Window [ Name: "Name of Window Specified in Go to Related Record step" ]
But got precisely the same result. Suggestions?
Using FMA 14 and FMS 14.
Many thanks in advance.