Hi all,
I'm trying something completely new for me and have no idea whether i'm on
the right track or not. I'm trying to create a relational database in Excel.
I have a workbook containing 4 worksheets. Each worksheet has a table as
follows:
Sheet 1: contains a table of 'Suppliers Details' (ID, Name, Location)
Sheet 2: contains a table of 'Clients Details' (ID, Name, Location)
Sheet 3: contains a table of 'Products Details' (ID, Name, Description, Price)
Sheet 4: contains a table of 'Sales Details' (Date, Product ID, Supplier ID,
Client ID, and a lot other fields).

I know how to apply formulas to each individual table to count all sorts of
information from that table. But i don't know how to count information that
needs to be gathered from more than one table at a time. For example:
How many 'Products' with a specific 'Price' were sold to 'Clients' located
in a specific 'Location' on a certain 'Date'?

I did some readings about using MS Query but i'm not having a good start at
all. I'm just scratching the surface and i'm already getting an error message
'This data source contains no visible tables'. What am i doing wrong? and
before that, am i on the right track in the first place or what i'm trying to
do is not achievable in Excel? I know this is probably much easier in Access,
but my employer insists on using Excel.

I'm using Excel 2003.
Looking forward to any help or clues you can give me.
Thanks in advance
Tendresse