Please Help - Need Advice

[Steven.Ashby82]

Ok guys, So I'm trying to create a new database which would replace a system that we (team) are currently using excel for.

At the end of every day each team member (upto 10 people) have to complete a daily job sheet. This needs to contain the following...

1. Technician Name
2. Date
3. Shift/Role
4. Room
5. Time
6. ReportedBy
7. Support/Problem
8. Comments

Each person would have approximately 20 records worth of information so it would be really useful to have 1-3 that copy the last record so that the process is streamlined.



I understand a bit about split forms but could I have it so that the table on displayed information entered filtered by the Technician and Date that are currently selected? This in theory would the recreate the visual of what was being done in Excel to the user.


I understand this is a very broad request.



I attach a very very simple design at the moment with no real coding.

 

[gemma-the-husky]

where you get repeating groups often suggests the right approach would be to split the table

eg have a shift table

technician
date

(note that the shift/role itself may be redundant, as it may be dependent on the technician)

then the support comments are the things that change for each case - so you have a case table to store those bits.


shift table
shiftid (Pk)
technician
date

case table
caseid (pk)
shiftid (fk)
Room
Time
ReportedBy
Support/Problem
Resolution etc

it's another way of thinking about your data.