Normalizing???

[epete367]

I have a table [Orders Special Products Details] with fields: OrderID,
ProductID, SpecialOrderID, UnitPrice, Quantity, Discount, GiftMessage,
ShipDate1, ShipDate2 - ShipDate12. Items can be shipped 3x, 6x, 9x or
12x per year (which is why I created 12 ShipDate fields). The table is
related to the [Orders] table, the [SpecialProduct]table. I now realize
having all of the ShipDate fields makes my table a mess. I need to
break it down further but am not sure how. I tried creating a table
[ttblSpecialOrderShipping] with the fields OrderID, SpecialOrderID, and
ShipDate. However, when I try to query bringing info from the three
tables together I can't. Any suggestions or guidance?

 

[Van T. Dinh]

Assuming [SpecialOrderID] is the PrimaryKey of your Table [Orders Special
Products Details], create a Table [tblOrderShipDate] with the ForeignKey
[frg_SpecialOrderID] that links it back to your [Orders Special Products
Details] in a One-to-Many relationship, i.e. Records in [tblOrderShipDate]
are Child Records of an Order Record. This way, you can have as many Child
Records as you need, be it 3, 6, 9 or 12 and it can even handle when, let's
say, you decide to ship twice a month for 12 months / year!