HillTJ
To train a dog, first know more than the dog..
- Local time
- Today, 05:12
- Joined
- Apr 1, 2019
- Messages
- 731
Hi, I hope my description makes sense. I have the following many:many relationship. Thus,
tblAccident
Does this make sense? It’s probably simple to do. Appreciate any feedback.
tblAccident
- IncidentID-PK
- Other fields….
- AccidentID-FK (1 to many with IncidentID)
- SectionID-FK (1 to many with SectionID)
- strText (this is where details are recorded)
- SectionID-PK
- strSectionDescription (could be “Initial Investigation”, “Immediate Actions”, “Witnesses” etc)
- SectionPriority (used to sort the order of the “lookup”)
Does this make sense? It’s probably simple to do. Appreciate any feedback.