Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Normalizing???

Discussion in 'Information Technology' started by epete367@optonline.net, Nov 1, 2005.

Tags:
  1. epete367@optonline.net

    epete367@optonline.net
    Expand Collapse
    Guest

    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?
     
  2. Van T. Dinh

    Van T. Dinh
    Expand Collapse
    Guest

    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!

    --
    HTH
    Van T. Dinh
    MVP (Access)



    <epete367@optonline.net> wrote in message
    news:1130794977.688108.273460@g49g2000cwa.googlegroups.com...
    >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?
    >
     

Share This Page