Thanks for taking the time to respond. I'll answer your questions and then maybe you'll have more input?
1. You mentioned repeating groups in the status table. Did you mean the parts table? I do have a repeating group in that table; unfortunately our accounting software stores the part...
My database is to track customer incidents. Can anyone tell me if my relationships look ok? I'm a remedial access user to any input would be appreciated. Thanks in advance for the help.
You're correct in your assumption of one machine per incident. There will be multiple employees involved in each indicident though, hence the employee role table. I also need to know what parts are required to repair the equipmenet, hence the part failures details table.
The reason I have...
Hello everyone. I'm new to Access and I've been having trouble grasping the whole normalization thing, hence i'm making this post to see if i'm approaching this database correctly. Here is what i'm trying to do:
Our company has thousands of machines in the field. These machines are sold...