Searching in related tables
Posted: Mon Dec 21, 2009 8:51 am
I've got a invoices table where the company name does not actually appear as a standalone field - the numeric primary key for the company is there, but not the name. The data is pulled over via the relationship.
If I want to use fmSearchResults for searching in the invoices table can I select the related table for one of the search Text Fields? Actually, I know I can, the question is should I?
If I want to use fmSearchResults for searching in the invoices table can I select the related table for one of the search Text Fields? Actually, I know I can, the question is should I?