Setting up a database

S

Spencer Hutton

I am wanting to set up a database to track items priced for buyers. i just
cant figure out the best way to set it up. i would like for each record to
contain personal info like name and address and all that. but there may be
anywhere from 1 to 25 items priced for each buyer. typically it would be
3-5. i am familiar with VBA and would like to create an application to view
and analyze these records. it just seems like each record should be one
row, but i cant seem to figure out how to include 3-5 items or even 25 items
separated with individual costs on one row. any advice on starting a
database like this would be helpful. or would Access be a better program to
use. i would rather use excel since i am much more fluent with it. TIA.
 
J

JulieD

Hi

my money's on Access as its designed for relational data - which is what you
have

Cheers
JulieD
 
T

Tom Ogilvy

sounds like you need to use an Access database with two tables.

One table would have your customer information on a single row with a unique
identifier such as a customer id

The second table would be your price informationl. Each record (row) would
be price information on a single item for a single customer. So each of
these records would contain the customer id and the item identifier and the
special pricing information.

You then can do a join on the tables if you need information beyond the
customer id (such as shipping address or something).

If you had a third table that represented an order, you would have the
customer id and item identifier in each record for the order which would
allow you to join to table 2 to get the unique pricing for that customer for
that item.
 
Top