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.