Hi Amin

Have a look at the answer I gave to this question in the General Questions
section
--
Wayne
Manchester, England.



"Amin" wrote:

i want to create a database for my makeup shop. I know i would have a table
for all the products but i want to also track customers who buys what product
so that i can always inform them of new itmes.

i want to now if i need just one table or i need more than than.
my table will have fields for prices and total amount. this will be and
invetory for the shop that should show what we have as orders and what is
Purchase orders.