Hi Nick,
I only have the basic packages no SQL servers etc. This is hwy its so
difficult for me to complete the task. Ive created the tables in access and
have linked by relationships but im not sure if it will work, i want to try
and only have 15,000 client names rather than that one name repeated four or
five times becuase of what they have purchased.

are you any good with using access,
my email address is

it might be easier to communicate that way.

Thanks
"NickHK" wrote:

Well,
If you are talking big numbers like that you will save yourself headaches in
the future by going with a database backend and possibly using Excel as a
front end.
Database-wise, Access is easy to set-up, or you have the free MySQL for a
real DB-management system.

As far as I remember, Access has various wizards available that would
construct the basic structure for you. After that you could either use
DataGet External DataNew Database Query or Pivot Tables in Excel to
display desired results.

NickHK

"Help Me Please" wrote in message
...
Nick,
Yeah im open to suggestion but i dont know how i need to go about it, as
you
can imagine its a large task with over 15,000 customers, im talking about
90,000 + lines, id be open to any suggestions


"NickHK" wrote:

It would more straight forward to setup in a database application, e.g.
Access.

NickHK

"Help Me Please" <Help Me wrote in
message
...
Im trying to create a database of customers who have purchased a
number of
products. on each product page will be a list of customers, from these
list
of customers i want a contents oage to be auto populated with their
names
and
onyl ensure that they appear once. i also want to have in place a tick
sheet
to if the customer appears on more than one page.