Hi,

I'm developing vb6 application for shop.i want to add details of new customer.If again tht customer comes how can i keep his records,to have a new record or can i join tht details for the current record.

thanks.

Nadee

Maintain 2 tables as CustomerMaster & CustomerPurchases (any meaningful names)
[u]First method</u>
(i)If user has customer details allow user to create customers using customer master interface & save in CustomerMaster table.
(ii)When customer comes to purchase goods, add customers purchases details into CustomerPurchases table. save customer code,itemcode. etc.

[u]Second method</u>
(i)If user doesn't know customer details till customer comes to purchase goods(walk in customer) then use customer ID card or something like that when creating customer code.Check whether it exists(customer code) in Customermaster. If so check whether those details are correct and add customer's purchases details to customer purchases using that customer code
(ii)If customer doesn't exist in CustomerMaster table, create the customer and save in CustomerMaster then add purchase details to CustomerPurchases table.


nalaka hewage

Thanks for u'r advices.If I want to take all history details of particular customer including customer personal details and date and the purpose he comes on particular days.....How can i retrieve those details.

If you've designed your table as i mentioned, you can retrieve those details from CustomerPurchases table.
If you want to retrieve a customer's details about past purchases, etc..
Let the user to enter particular customer's customer code. then show customer details (Customer Name, Address, etc..) from CustomerMaster table and select relavant records from CustomerPurchases(Items bought, Date,purpose) table for that customer.


nalaka hewage