Serial or Date field for relating???
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....