Is it possible to find matching records in my database using a list of imported records.

my existing database contains a field name BinRef and contains a seven digit variable e.g.: 1234567 plus an ImageRef which always has 5 Digits 12345

I have another imported table which contains up to 100 records with examples of the variables i need to find in my database above.

Without manually finding every match using the "new record request" how can i script a find function that will match all 100 records in my imported table. ?

Thank you in advance to all Guru' who can help.

If you define a relationship matching on the field/s you want to use for the find, you can then use the Go to Related Record script step and select the 'Match all records in the current found set' option.

Not sure why this is necessary though. Perhaps importing into the "real" table, with the option to update matching records in the found set would be a better choice?

 

 

Edited March 10, 20196 yr by comment

Thank you comment once again, you make it appear so obvious ! I keep over thinking these challenges...

Ill try your suggestion, Top Man!