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.