Help with Table Normalization

JimboUK

Registered User.
Local time
Today, 07:21
Joined
Jul 21, 2003
Messages
10
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
 
No on has any ideas? Really need some guidance on this one.


Jim
 
Try reading all this on Many-to-Many relationship(s)

Linking tables on memo fields is not possible... (or not good practice) either way, dont go that way...

Regards

P.S. Try searching yourself before you post a question on the board :mad:
 

Users who are viewing this thread

Back
Top Bottom