If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Relational Database Layout
What I would like to do is create a database to track sales, customer info
and customer demographics using 3 separate tables: Customer Info(name, address, phone, etc.), Sale info(what was purchased, date, size, etc), and Demographics(Gender, age, income, etc). I have the three tables populated with the needed fields but I'm having a problem creating the relationship setup so that I can say look up a customer or product and see what product that customer purchased or select a product and see which customers have purchased it. This is a beginner question, which I am, but would like a little help. |
Thread Tools | |
Display Modes | |
|
|