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


New Record/Request