Are my tables correct as well as established relationships in new Access 2016 database

Frank Freese
Frank Freese used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Software & Systems Engineer
Commented:
This is how i would design it

Clipboard01.jpg

Author

Commented:
John,
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
John TsioumprisSoftware & Systems Engineer

Commented:
Glad i helped you Frank

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial