Forum Discussion

DawnRene3's avatar
Qrew Trainee
2 years ago

Trouble with query comparing field data between two unconnected tables

I'm trying to get a query to work to compare if data contains similar letters between fields in the two tables and output text from another field.

Writing the formula in Table 1
Desired output would be if [product code] (FID 116) in Table 1 contains 'EL' and [Product Code Selection] (FID 8) in Table 2 (bs9xqc72i) contains 'EL', list value from Table 2, Name (FID 6). I know I need to use the GetFieldValues(GetRecords( query but I'm new to queries and am lost as to what to do next. Any help would be much appreciated.

Dawn Rene
No RepliesBe the first to reply