Frank Freese
asked on
Are my tables correct as well as established relationships in new Access 2016 database
Folks,
I have attached a Word 2016 document outlining my objective. I am in the process of creating a database on Excel Topics, SubTopics, Issues, and Solutions. There are 4 tables currently set up:
tblTopic; tblSubTopic; tblIssue; tblSolutions.
Where I need help is feedback that I have correctly linked my various tables (Relationship diagram is in the document) and is my structures and relationships correct before I do something stupid like start over again.
It has been 7 years since I last used Access and too many senior moments are getting in the way.
Thanking you kindly.....
Frank
Question-on-structure.docx
I have attached a Word 2016 document outlining my objective. I am in the process of creating a database on Excel Topics, SubTopics, Issues, and Solutions. There are 4 tables currently set up:
tblTopic; tblSubTopic; tblIssue; tblSolutions.
Where I need help is feedback that I have correctly linked my various tables (Relationship diagram is in the document) and is my structures and relationships correct before I do something stupid like start over again.
It has been 7 years since I last used Access and too many senior moments are getting in the way.
Thanking you kindly.....
Frank
Question-on-structure.docx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Glad i helped you Frank
ASKER
I can see my error and thank you kindly for correcting my design. Close but no cigar but close isn't good enough. Happy Thanksgiving.
Frank