MS Access Relationships
Posted on 2014-10-07
I am creating a Database in MS Access to capture all Field Interviews for a police department so they can track everytime they interact with a subject. It will be relatively simple, however I am wondering if there is a need for relationships and referential integrity or is it easier to just have all of my fields in one table. I want to be able to make any of the fields that I have listed below searchable to anyone accessing the DB. Here are the fields:
Date, Officer name, Subject Name, case ID #'s, DOB, Race, SSN, Location of Contact, Subject Address, Phone #, Vehicle info, Reason for contact, HT, Weight, Hair.
The only fields that will have to be filled out 100% of the time are the Officer's name and subject's name and possibly the case ID's as most of the contact will be made regarding a case #. As of now, I am just using one table and creating my forms based off of that. I just want to make sure that I will not run into any issues later down the road when trying to search all records relating to a DOB for example. Thanks for you time.