Results 1 to 2 of 2
  1. #1
    Join Date
    May 2012

    Unanswered: same fields in different tables

    Hi, I'm kind of new to databases. I have taken a database class but I'm working with my first database project. I have two tables, one with products, onewith customer information and one with order information (Product name, quantity, price etc). I'm trying to figure out the best way to tie the order information with the the customer information. Can I copy some of the customer fields to the order table or should I do some kind of query? If I could get some feedback I would really appreciate it.

  2. #2
    Join Date
    Apr 2005
    To tie the order and customer together you need to create a relationship between the two tables and the specific fields.
    Web Database Software - Build your own php mysql database.

Posting Permissions

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