Users (prikey base on the Users table)
Pdate (purchase date) don't use the word Date as a feildname
TTYPE what had been ordered (dvd cd game) don't use the word type as a feildname
QTY number ordered
price can't use the price from the table cause if someone places a order know and the need to store that price
cause if you don't when the price goes up the old orders will show the new price values.
Last edited by myle; 11-02-07 at 15:34.
hope this help
See clear as mud
the aim is store once, not store multiple times
Remember... Optimize 'til you die!
Progaming environment: Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010 VB based on my own environment: vb6 sp5 ASP based on my own environment: 5.6 VB-NET based on my own environment started 2007 SQL-2005 based on my own environment started 2008 MYLE YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.