Avatar of Frank Freese
Frank Freese
Flag for United States of America 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
Microsoft Access

Avatar of undefined
Last Comment
John Tsioumpris

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
John Tsioumpris

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Frank Freese

ASKER
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 Tsioumpris

Glad i helped you Frank
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck