A readout Data Table

[laythss]

Background:
I have the foloowing tables
tblClient:
ClientID (PK)
ClientName
other client details

tblMachine:
MachineID (pk)
SerialNumber
ClientID (fk to tblClient)
other machine details

tblProduct
ProductID (PK)
ProductName

Question:
I am trying to build my most important table now, the one that will store the readout data for each product for each machine. The readout data is collected from each machine weekly, so I was thinking something like this:
tblReadout:
year_date
month_date(pk fld1)
day_date(pk fld2)
ProductID(fk to tblProduct)
MachineID(fk to tblMachine)
ReadoutAmount

Is this the best way of constructing this??
Layth

 

[PHV]

Why splitting the date in 3 fields ?[tt]
ReadoutID AutoNumber PK
ReadoutDate DateTime[/tt]
...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[TheAceMan1]

How are ya laythss . . . . .

Have a look here: Normalizing Tables Table Relationships

See Ya! . . . . . .