Hello,
I would just like to get your thoughts/ideas/suggestions on how I should go about createing a VERY SIMPLE purchasing system. A friend has asked me help him develop a simple purchasing database.
Just off the top of my head this is what i have come up with for the table lay out.
Tables = Bold Text
Customer
Name
Address
Phone Number
E-Mail Address
Credit Card Number
Orders
Order Number
Product Number
Customer Name
Customer Address
Customer Phone
Cumster Credit Card Number
Products
Name
Manufacture
Model Number
Price
Quantity
Is there anything else that i would need. Is there a better way to arrange the tables and feilds within them? I am open to any thoughts/ideas/and suggestions.
thank you in advance