Normalisation problem

[scottappleford]

Hi

I have a timesheet db.

An employee can have upto classification for hours -

1. RT - Normal time
2. OT - Over time
3. DT - Double time

I have a main form which the theme is on the task and per day and this can have many employees, which is the sub form. If someone works RT, OT in a day it means there names appear twice when the hours are entered. At the weekend it is always DT.

I have the RT, OT & DT as a look up for the field.

Does this meant that i could set up the datasheet subform better?

Thanks

 

[scottappleford]

Thanks Pat - will check it out

 

[scottappleford]

Can you re-post

Pat

The link is still not working - would it be possible to upload the sample in this thread?

Thank you

 

[scottappleford]

Thanks

Pat

Thanks for that - I am going to have RT, OT & DT fields and then leave the ones empty that are not used. This way i only see the employee name once on any timesheet.

All the timesheets are set up for a work description by company per day.

Hopefully this will work.

Scott

 

[JoeCruse]

Pat,

Thanks for the sample! I originally set up 2 data entry forms that each have repeating entries that are non normal (C and S in one, O and N in another). I've now combined both tables into a more normal structure where C, S, O, and N are now all in an Analyte field/column and the data is in a Concentration field/column. This table is linked to a main sample table, with the 2 linked by PK-FK.

Using your example, I made the underlying queries and was able to build a data entry form that looked and worked (for the analysts) just like the old, non-normal setup. I did not use the code you had in the After Update section of the data fields. We never have null fields for these, they always have data. Deleting a record in the form does delete the underlying records in both tables without any issues.

I'm going to try this on some other data where the table structure was set up in non-normal fashion and will require more than 3 or 4 "columns" and see how it works.

Thanks again!