Look into the FilterValues function. j.
On Mar 2, 2011, at 9:43 AM, John Montana wrote: > Hi all, > > we are still in the drawing phase and have doubts about in which direction > to go. > > We have two tables, say tableA and tableB, both with data and the use of > keywords in records. The keywords are in several fields. the field names are > the same in both tables. > Example of fields: color, height, width, depth, form, shape, age, > > At a given moment we need to 'compare' keywords from tableA with keywords > from tableB, where the final goal is to find 'matching' records. > > The result should be in levels. > When 2 values are the same: can be match (with list of records) > Between 3 and 5 values: possible match (with list of records) > More than 5 values: more than possible (with list of records) > > I was thinking in the direction of custom functions to compare two lists, > one in A and one in B, but don't know what to do to show a list of possible > matching records. Portal, table with records in list view.....and showing > that as popup window.... > > Or do way have to loop through records, compare and flag them.... > > Suggestions, ideas, hints, advice, everything is more than welcome right > now... > > TIA -- Jonathan Fletcher FileMaker 9 & 10 Certified Developer Fletcher Data Consulting [email protected] http://www.fletcherdata.com 502-509-7137 Kentuckiana's FileMaker Users Group Next meeting: March 22, 12:00 pm to 3:00-ish Listserv signup: http://fmpug.com/mailman/listinfo/louisville_fmpug.com Blog: http://www.kyfmp.com
