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 ]