You’re offline. This is a read only version of the page.
Announcements
Hi, need a bit of advise,
I've been tasked with creating an end of shift report, the premise being that all the primary details (date, shift, weather etc) are captured in one table (tbl_shift_reporting), then the user can create new detail items to add to the report, and or select existing detail items/issues that are still valid from a seperate table (tbl_shift_reporting_detail) to add to the information to be sent out.
The issue i'm trying to get my head round is how to capture the new/selected items for each shift.
The new/selected items are in a second table (tbl_shift_reporting_detail), and could be added to many reports depending on how long they are valid for. I need to be able to record (in possibly a 3rd table?) which records they selected?
Because they are valid for multple reports, a 1 to many relationship/ standard lookup field between the 2 existing tables wouldn't work, I'm struggling to work out the best way of achieving this.
I need to be able to record what records were selected for each shift, but having a whole new table to record each of the detail records selected (1 row per item selected), seems a bit excessive?
Any advise would be appreciated!!
Share
Report
All responses (
Answers (
717
