Forum Discussion
JamesTrory
7 years agoQrew Assistant Captain
Hi,
I know, sorry this is getting quite complicated. I really do appreciate your help so far, I feel like I'm getting closer to the solution.
This is the process I want to try and achieve:
1. When a ShotID has the JobID modified and the Reshoot field IS NOT set to YES, create two new records in the Reshoot table - one with the old JobID and one with the new JobID.
2. Write YES to the Reshoot field of the ShotID (using the Report Link for the RecordID#).
3. When a ShotID has the JobID modified and this time the Reshoot field IS set to YES, only create a new record of the new ShotID in the Reshoot table.
So, first time the JobID gets modified add two records, every other time only add one record.
I'm still getting the problem where it is adding the old and new JobID records every time the JobID is modified.
I know, sorry this is getting quite complicated. I really do appreciate your help so far, I feel like I'm getting closer to the solution.
This is the process I want to try and achieve:
1. When a ShotID has the JobID modified and the Reshoot field IS NOT set to YES, create two new records in the Reshoot table - one with the old JobID and one with the new JobID.
2. Write YES to the Reshoot field of the ShotID (using the Report Link for the RecordID#).
3. When a ShotID has the JobID modified and this time the Reshoot field IS set to YES, only create a new record of the new ShotID in the Reshoot table.
So, first time the JobID gets modified add two records, every other time only add one record.
I'm still getting the problem where it is adding the old and new JobID records every time the JobID is modified.