Search results

  1. A

    Are my table relationships ok? Pic attached

    Much thanks for the input.
  2. A

    Are my table relationships ok? Pic attached

    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...
  3. A

    Are my table relationships ok? Pic attached

    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.
  4. A

    Need help/input with database design

    Which section should I look in? I didnt see anything in the Theory and Practice of Database Design section.
  5. A

    Need help/input with database design

    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...
  6. A

    Need help/input with database design

    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...
Back
Top Bottom