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.

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.

I would look for some prebuilt software. Unless you are familiar with
database development you cannot appreciate the complexity of this task or how
long it will take to build.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".


"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.

http://store.microsoft.com/microsoft...oduct/1219B1D1
--
~Your Friend Chris


"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.