MajP
You've got your good things, and you've got mine.
- Local time
- Today, 03:56
- Joined
- May 21, 2018
- Messages
- 8,870
Your tables and relationships do not seem correct as Pat points out and like Pat said cascade updates only work for the Primary Key to Foreign Key when referential integrity exists. Does not make sense here.
In plain words what does T-Scene-Shooting represent and how is it used. Also your names are problematic. NO special characters in any names (#,-) except for underscores. Can cause a lot of problems especially the #. Normally the letters ID are only used in a PK or FK. But you have IDsceneOrder and IDShootOrder which do not seem like PKs, FKs.
Is there a difference between the Scene Order and the Shot Order? Are they two seperate things?
In plain words what does T-Scene-Shooting represent and how is it used. Also your names are problematic. NO special characters in any names (#,-) except for underscores. Can cause a lot of problems especially the #. Normally the letters ID are only used in a PK or FK. But you have IDsceneOrder and IDShootOrder which do not seem like PKs, FKs.
Is there a difference between the Scene Order and the Shot Order? Are they two seperate things?
