Export records script based on the criteria of 2 fields
Apologies if this is not the right thread to be in...?
I have inherited a database that I need to do a job on. I have listed the 2 tables/fields that are the focus. They are not relational...
field- item's monetary amount
field- Item's purchase #
field- item's description
field- item's purchase #
the script needs to find records with a monetary amount field > $500 in table 1.
if found, and the item purchase # matches in both tables, a list of those exported records is the desired goal.
*it seems that the field- item purchase # should be global but it is not right now.