I have a Table (Customer Info) that includes a field “Type”. “Contacts”, “Suppliers”, and “Customers” are listed within “Type”. I am wanting to have a List Layout that would only include “Customers”, not all the records.
Set up your list layout the way you want it, but then perform a find for all records where the type field contains "customers". This can be automated with a script:
Go To Layout ["Customer List" ; (Customer Info) ]Enter Find Mode Set field [Customer Info::Type ; "Customers"]Set Error Capture [on]Perform Find Sort [Restore ; no dialog ]
You are the BEST!!!!
Retrieving data ...