I'm working toward making a web site to sell some apps I've written.
It will run VBScript with an Access DB.
I'm trying to decide on a DB layout, how does this sound?
Code:tblCustomer CustomerID 'auto numbered First Name Last Name Address 'Optional? Email 'Required tblPrograms ProgramID 'auto numbered ProgramName ProgramVersion FreeUpgradeFromVersionX tblOrders OrderID 'auto numbered CustomerID ProgramID ProgramVersion Date 'Order placed PayPalSaleID RegKey 'Users registartion key, could just use the OrderID? DownloadCode 'The ASP extention to create their download page DownloadAccessed 'Date-time when the download code is first used tblSupport OrderID 'or RegKey? SupportRequestEmailAddress 'the email address the customer used when asking for support Issue Action Result




Reply With Quote