PaulWilson
Registered User.
- Local time
- Yesterday, 22:34
- Joined
- May 19, 2011
- Messages
- 43
Folks,
I made a sample database of authors and books (after getting a bit of help from this forum). It seems to represent the classic many-to-many relationship. It works, but I am under the impression that I did not use the current "Best Practice" in making the form. For example, I used a table level lookup field in my junction table.
Also, when I delete a record the deletion is not complete and I have an orphan record even though I specified cascading updates and deletes with my referential integrity choices.
I attach a powerpoint slideshow showing the issues and thank all in advance for any assistance you might provide.
PaulWilson
I made a sample database of authors and books (after getting a bit of help from this forum). It seems to represent the classic many-to-many relationship. It works, but I am under the impression that I did not use the current "Best Practice" in making the form. For example, I used a table level lookup field in my junction table.
Also, when I delete a record the deletion is not complete and I have an orphan record even though I specified cascading updates and deletes with my referential integrity choices.
I attach a powerpoint slideshow showing the issues and thank all in advance for any assistance you might provide.
PaulWilson
