Normalization

[Mike Revis]

Hi Group
Win XPpro, Access 2000

Just a curiosity question more than any thing else.

In my tblJobData I have fields for Shipper, Consignee and DeliverTo.

I also have fields for ShipperRef, ConsigneeRef and DeliverToRef.

Ref being Reference Number.

Since less than 5% of shipments actually require a reference number, in the
interest of normalization, would/should I have separate tables for
ShipperRef, ConsigneeRef and DeliverToRef?

As always any thoughts, comments or suggestions are welcome.

Regards

Mike

 

[Guest]

Yes, I would put in a table for reference numbers and possibly a second one
for reference type:

tlkpReferenceType
RefTypeID - Autonumber (PK)
RefDescription - Text

tblReference
RefID - Autonumber (PK)
RefTypeID - Long Integer (FK)
JobID - Long Integer (FK) from tblJobData
RefNumber - Text (since the ref number probably has text too)

 

[Mike Revis]

Thanks Bob, that's kind of what I was looking at.
Mike