How to hide records from the List in a match field?
i was able to filter records using a match field.
Table - Companies
pk_companies_id = primary key
companytype = value list = supplier , customer
c_supplier_only = calculation "Supplier"
Companies::pk_companies_id = Companies_Supplier::pk_companies_id AND
Companies::companytype = Companies_Supplier::c_supplier_only
when im viewing the company_supplier table , i would like to view the suppliers only, without any "blank" records
whats happening is that the records are showing all the companies, the suppliers are listed, you can read them while the customer are all "blank"
how to remove/hide these blank records?