I'm having problems coming to terms with this and need some help. I have 2 main tables as follows:
tblLog
Log_Subject
Log_DateOpen
Log_TimeOpen
Log_initials
Log_Manhours
Log_TaskCode
Lof_Problem
Entry - would like to use this for both ETR and Log entries as is a memo field
tblETR
ETR - primary Key
Equipment
Station
SSCode
Date_Open
Time_Open
Opened_By
Status
ETR_Ref
PCN
Date_Close
Time_Close
Closed_By
Problem
DR_Ref
Fix_Action
Manhours
Parts_Used
This is a maintenance database with ETR (Electronic trouble Report) and a separate Log. These two tables will need to have a many-to-many relationship (I think) as each ETR can have multiple Log entries (everytime specfic crew does some work on equipment) and each Log can have multiple ETR entries.
This was a flatfile database and converting it to Access. The boss wants it to function like it always has, which is there has to be an ETR opened on each piece of broken equipment and the main details of the ETR will be dumped to a Log which can be printed or read by the manager (for instance, quick view of what happened on night shift). On the other hand there are some jobs that will not require an ETR, such as, replacing consumable parts, laser toner, etc. For these we would just generate a Log entry and Not an ETR.
I would like to be able to use the Entry memo field for both the log and ETR. This would be the basic Action taken field that would be filled in, in either a log entry or ETR.
Any help on Normalizing this beast would be greatly appreciated.
Jim
tblLog
Log_Subject
Log_DateOpen
Log_TimeOpen
Log_initials
Log_Manhours
Log_TaskCode
Lof_Problem
Entry - would like to use this for both ETR and Log entries as is a memo field
tblETR
ETR - primary Key
Equipment
Station
SSCode
Date_Open
Time_Open
Opened_By
Status
ETR_Ref
PCN
Date_Close
Time_Close
Closed_By
Problem
DR_Ref
Fix_Action
Manhours
Parts_Used
This is a maintenance database with ETR (Electronic trouble Report) and a separate Log. These two tables will need to have a many-to-many relationship (I think) as each ETR can have multiple Log entries (everytime specfic crew does some work on equipment) and each Log can have multiple ETR entries.
This was a flatfile database and converting it to Access. The boss wants it to function like it always has, which is there has to be an ETR opened on each piece of broken equipment and the main details of the ETR will be dumped to a Log which can be printed or read by the manager (for instance, quick view of what happened on night shift). On the other hand there are some jobs that will not require an ETR, such as, replacing consumable parts, laser toner, etc. For these we would just generate a Log entry and Not an ETR.
I would like to be able to use the Entry memo field for both the log and ETR. This would be the basic Action taken field that would be filled in, in either a log entry or ETR.
Any help on Normalizing this beast would be greatly appreciated.
Jim