Hey all. I am relatively new to actually building databases. Funny thing is that I took several classes on database design and understand the terminology and rules, but there is absolutely something to be said about the "street" experience when actually being able to put something together. That is what I am lacking, but am learning as I go.
So here is the problem. I am starting a database that is in Access 2010. I thought that I had normalized properly, and built the tables appropriately; however, when trying to create realtionships I am unable to. For some, the relationship type states that it is "indeterminate", which I know is not good. Plus, I cannot enforce referential integrity on between a main table I have and all its corresponding tables. I have a feeling this is where I am going wrong. I will try to make this as brief as possible as I know it sucks having to read dissertations on the forums.
Here is the background - we have a dispatch department that needs to keep track of incomplete jobs, which is the premise of the whole database. I have inserted an image with the relationship diagram (you may have to click it for a larger size.
The major players are as follows:
MA = Management Area (synonymous with region)
FSM = Field Service Manager
EA = Eastern Arc - this is a specific question that may or may not be on any given tracker item. They are presented on a form as a combo box.
I am hoping this is not so horrible it makes some of you sick!Seriously though, I cannot figure out any better way to separate the larger Tracker Table in this situation. I am quick to respond if there are any clarification questions. Thanks!
FYI - The farthest table to the right in intentionally cut out because I am not having any issues with that portion of the database.
![]()