Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting up a database
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting up a database
Hi
my money's on Access as its designed for relational data - which is what you have Cheers JulieD "Spencer Hutton" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting up a database
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. -- Regards, Tom Ogilvy "Spencer Hutton" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
setting up and using a database in excel 2003 | Excel Discussion (Misc queries) | |||
Setting up a database in excel | Excel Worksheet Functions | |||
I nedd help setting up a database on my customers | Excel Discussion (Misc queries) | |||
Easy (?) questions for setting up a database | Excel Discussion (Misc queries) | |||
Sending email via macro- setting the importance setting. | Excel Programming |