AnsweredAssumed Answered

Table Help

Question asked by c0nsilience on Jan 21, 2016
Latest reply on Jan 22, 2016 by siplus

Hi all,

 

So, I'm building a very basic database that will track inspections done at auctions.  There isn't a lot to it, but I'm having a difficult time with the table structure.  What I would like to be able to show is:

 

  • Number of inspections per week
  • Number of inspections per week, per auction site
  • Number of inspections per week, per employee, per auction site

 

I would like to be able to accomplish this with the least amount of tables and complexity that is possible.  To keep it simple and clean.

 

I've tried building it with an employee table, an auction table and an inspection table between the two (with foreign keys from both employee and auction).  I'm still not able to make it work right.

 

Any ideas?

Outcomes