hncnscr Posted April 21, 2008 Share Posted April 21, 2008 I have a Lead Table with three fields Type, Source and calcTypeSource. Type is based on a predefined value list that contains items such as newspaper, website, search engine. Source is a free-form text field that contains info related to the Type in each record. For example, a record may have Type = search engine and Source = Google. Now, I have a value list of these items using the third field, calcTypeSource, which is a calculated field joining the other two fields in a string. I use this value list to populate a field in a non-related table, Contacts::Leads This list is getting rather long. I would like to have two fields in Contacts, one for Type and one for Source. If I select Type=Search Engine, I would like Source to only show me sources that match that type. Is this doable? Any help is appreciated. FYI, FMP 9 db running on FMP 9 Server Link to comment Share on other sites More sharing options...
AHunter3 Posted April 21, 2008 Share Posted April 21, 2008 http://filemakertoday.com/com/showthread.php?t=10930&highlight=adovada Explanation in post #4; example file available in post #15 Link to comment Share on other sites More sharing options...
hncnscr Posted April 22, 2008 Author Share Posted April 22, 2008 Thank you! This was a great help. Link to comment Share on other sites More sharing options...
By Soliant Consulting,
By Soliant Consulting,
By Soliant Consulting,
Recommended Posts