ok guys thanks a lot for all the input that you have given... i got the concept now and i am going to implement it... and will shoot a lot of questions once i start coding.... looking forward for your suggestions and help....
Joined: 13 Jun 2007 Posts: 826 Location: Wilmington, DE
Happy Monday, girish!
The more I think about it, you should really add the customer number to your output file. The main reason is that product and order number will not be unique within the database and you may need to distinquish that.
Joined: 07 Nov 2005 Posts: 1105 Location: The Netherlands at Hole 19
The key of product might be unique but there are more than one products belonging to one category. That's what's meant. And.......did you ever think about the next requirement of your customer? Once he got the first report he will ask you for a list showing the behaviour of the clients.
Anyway: develop your application and when you have serious IMS questions post them. We will judge them and if relevant answer; we did the redesign you build