Skip to Content
0
Former Member
Dec 06, 2006 at 09:00 AM

Regarding Table management

20 Views

Hi All..

A customer will place an order for few items to a company.

Company will make sales order, which will contain the customer name and items list and their price.

Is there any table, which will store the sale order data..??

If so, how the system will assign the number of items (say 10) with one customer..???

If we want a report reflecting the details of items per customer, how to fetch the data..????

How this type of data is maintained in the database tables..??

Please give your ideas/suggestions....

Regards

Pavan