Our company sage act have all customer orders data in sage act so the company want to show all orders agains every customer email.
i had tried to solve this problem. i had created a new tab in contact & use Table | IT Add On service but this product create their own tables so i had failed to create custome queries and filters on the fields of each customer email address.
any one tell me how is it possible to show each customer order history again each customer email addres.
For Example our Contect have these tabs:
1. Customer Order Number
2.Customer Billing address
3.Customer Dilivery Address
4. Customer email
5.Customer product price
let suppose a customer "Umar" 60 orders and "Ali" 50 orders in Sage Act database. now our goal is . when i will put "umar" customer email address so sage act automatically create a query and fetch only "Umar" orders.
i think this example make sence to understand what i want to create in sage act.