I have two separate fields called "Customer" and "Suppliers"
The table logic is if the Customer Name is blank then there will be a supplier name filled and vice versa
Now I need to create a list box or a field where I want to show Type ie.Customer,Supplier and then after the selection the data needs to be refreshed based on that.
