DavidT_macktool
Well-known member
I cant get the second tier of a relationship to work. Here is the structure:
Setup Operations -> one to many -> Setup Fixtures -> one to many -> Setup Photos.
Keys:
Setup Operations: PartId, OperationNumber
Setup Fixtures: PartId, OperationNumber, FixtureNumber
Setup Photos: PartId, OperationNumber, FixtureNumber, PhotoNumber
I am setting up a relationship that will cascade updates and deletes between the tables. The Setup Operations -> Setup Fixtures relationship works fine, the next level does not.
What I have tried:
At first I had all 3 tables in 1 diagram with relationships set just like I described in the structure. Setup Photos do not cascade when Setup Fixture/FixtureNumber is changed.
Next I split the diagram into 2 separate diagrams.
Setup Operations -> one to many -> Setup Fixtures
Setup Fixtures -> one to many -> Setup Photos
This configuration led to a FK relation error with the Setup Fixtures table when manipulating the Setup Photos Table.
What I need help with:
Can someone inform me with the correct way to structure this relationship so that if a Setup Operation table OperationNumber is changed all related records are updated. Also if a Setup Fixture table FixtureNumber is changed or deleted all the Setup Photo table records are updated.
I tried to keep this short, I will provide more/better information if requested.
Setup Operations -> one to many -> Setup Fixtures -> one to many -> Setup Photos.
Keys:
Setup Operations: PartId, OperationNumber
Setup Fixtures: PartId, OperationNumber, FixtureNumber
Setup Photos: PartId, OperationNumber, FixtureNumber, PhotoNumber
I am setting up a relationship that will cascade updates and deletes between the tables. The Setup Operations -> Setup Fixtures relationship works fine, the next level does not.
What I have tried:
At first I had all 3 tables in 1 diagram with relationships set just like I described in the structure. Setup Photos do not cascade when Setup Fixture/FixtureNumber is changed.
Next I split the diagram into 2 separate diagrams.
Setup Operations -> one to many -> Setup Fixtures
Setup Fixtures -> one to many -> Setup Photos
This configuration led to a FK relation error with the Setup Fixtures table when manipulating the Setup Photos Table.
What I need help with:
Can someone inform me with the correct way to structure this relationship so that if a Setup Operation table OperationNumber is changed all related records are updated. Also if a Setup Fixture table FixtureNumber is changed or deleted all the Setup Photo table records are updated.
I tried to keep this short, I will provide more/better information if requested.