AnsweredAssumed Answered

Prevent duplicate record creation based on parent table?

Question asked by ezeitgeist on Aug 29, 2017
Latest reply on Aug 30, 2017 by philmodjunk

I have table setup as such:

 

ScenesList::Scene_ID <--> ShootingSchedule::Scene_ID

 

I have a script that creates a record in ShootingSchedule table based off of the selected ScenesList record by having it create a new record in ShootingSchedule and inserting the ScenesList::Scene_ID into the ShootingSchedule::Scene_ID.

 

I want to PREVENT the ability to create a ShootingSchedule record that contains the same Scene_ID.

 

Would this work?:

 

Set Error Capture [ On ]

Perform Find [ Restore ]

If [ Get ( FoundCount ) = 1 ]

Exit Script

Else

New Record/Request

...

Outcomes