hi every one
i have many times to discover the right way to create a sales bill with advanced way
but all my results goes to fail
i try to create a view from my sales table
sales table fields is :
1- company name
2- responsible name
3- date\time
4- customer name
5- products category
6- product(s) name
7- Quantity
8- Sub Price
9- Tax Value
10- Discount
11- Total Price
witch take all this data in view and print it
but if i deal with many category and each category have many products under , what should i do to view the product No1 & 5 form category No1 and product No 3 & 8 & 9 form category No2 etc,...
i have many ideas but for all
i need to create a sales craft like what found in the big trading websites
how could i do this
if you have some help please tell me ...
thanks a lot