AnsweredAssumed Answered

Script to delete related records from other db after import

Question asked by jthulin on Apr 13, 2016
Latest reply on Apr 14, 2016 by jthulin

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 ]

Delete Record/Request

 

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.

Outcomes