N
Neill
I am selling personalised gifts on the Web (very small time but hopefully growing). Using FrontPage and Access 2000, I have managed to create ASP pages to collect the customer's details as well as the the personalisation details for the products. The customer can, and usually does, order many items - all with different personalisation i.e. two mugs with the names Janet and John printed on them and one t-shirt with Mary printed on it. To avoid the customer having to enter their details over and over again both the Customer and the Order tables are separate to each other. The customer usually comes back to order more items later in the year.
I am able to retrieve the information from both tables, but for the life of me I cannot marry them up. Because the business is so small I can usually work out who has ordered what by looking at the time the orders were received........yes, really!!!
Can anybody offer a possible solution to the problem whereby I can tie-in personalised orders to a customer. I am not a programmer - just an enthusiast with a copy of "Running Microsoft Access 2000". I could even be persuaded to adapt the Access 2000 sample database "Order Entry" to fit my needs if that helps
Many thanks in anticipatio
Neill
I am able to retrieve the information from both tables, but for the life of me I cannot marry them up. Because the business is so small I can usually work out who has ordered what by looking at the time the orders were received........yes, really!!!
Can anybody offer a possible solution to the problem whereby I can tie-in personalised orders to a customer. I am not a programmer - just an enthusiast with a copy of "Running Microsoft Access 2000". I could even be persuaded to adapt the Access 2000 sample database "Order Entry" to fit my needs if that helps
Many thanks in anticipatio
Neill