Here's a situation I'm trying to replicate in a database. A CASE can be tied to multiple EVENTS and an EVENT can have multiple CONTACTS. Each CASE or a CONTACT can have a SURVEY.
I am unable to figure a way to accomplish the last task.
Any help is greatly appreciated!
-Jay
Note: Words in capitals represent tables.Create a table of surveys and include the primary key as a foreign key in the CASE and CONTACTS tables.
Not sure what is so difficult about this...|||Not sure what is so difficult about this...Losing a table made it easier I guess :)|||Thank you Blindman...I guess i was thinking out loud :D|||Glad to help. Welcome to the forums.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment