AnsweredAssumed Answered

Serial or Date field for relating???

Question asked by FMNewbie on Jul 9, 2012
Latest reply on Jul 9, 2012 by philmodjunk

Title

Serial or Date field for relating???

Post

Hi there... I know this is probably simple but I'm out of practice at this.  I have a new database that has two tables:  SHIFT REPORT and CASES.  SHIFT REPORT would contain all the information on who was working on a given day etc.  CASES wil contain information on events that happened throughout the shift.   I'd like to relate them by date so that on a certain date you could search the individual cases of the day, or the shift report for the whole day.   Presumably, the best way to relate them is by date... or should I create an auto-creation serial number for both tables??  

I'm a little lost.... 

Outcomes