AnsweredAssumed Answered

How to hide records from the List in a match field?

Question asked by starstuff on Jun 18, 2015
Latest reply on Jun 20, 2015 by philmodjunk

Title

How to hide records from the List in a match field?

Post

Hi All,

 

i was able to filter records using a match field.

Table - Companies

Companies_Supplier TO

 

Fields

pk_companies_id = primary key

companytype = value list = supplier , customer

c_supplier_only = calculation "Supplier"

 

Relationship

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?

 

Thank You!

 

Outcomes