Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2002
    Posts
    23

    Unanswered: Database Design question

    I have the following form:
    http://www.htc.net/~jspahr/porder.htm

    I want to store all of this information in a Access db.

    I have created the 3 tables below (ORDERS, BILLTO, SHIPTO).

    My question is how do I relate these tbales together?




    ORDERS
    --------
    orderID
    orderDate
    ship_kind
    fob
    terms
    deliveryDate
    acctNum
    qty
    itemNum
    desc
    unitPrice
    total



    SHIPTO
    --------
    shiptoID
    s_fname
    s_lname
    s_company
    s_addr
    s_city
    s_state
    s_zip



    BILLTO
    --------
    billtoID
    b_fname
    b_lname
    b_company
    b_addr
    b_city
    b_state
    b_zip

  2. #2
    Join Date
    Jul 2003
    Location
    Michigan
    Posts
    1,941
    Every order will have a ship to, so add ship to to your Orders table,
    then link the 2 fields together (1 to many).

    Every ship to will have a bill to, so add bill to to your ship to table, and
    link them.

  3. #3
    Join Date
    Jun 2002
    Posts
    23
    Originally posted by RedNeckGeek
    Every order will have a ship to, so add ship to to your Orders table,
    then link the 2 fields together (1 to many).

    Every ship to will have a bill to, so add bill to to your ship to table, and
    link them.

    Thanks, that worked. It wasn't making sense before for some reason.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •