AnsweredAssumed Answered

Export records script based on the criteria of 2 fields

Question asked by FrankRizzo on Mar 17, 2010
Latest reply on Mar 22, 2010 by FrankRizzo

Title

Export records script based on the criteria of 2 fields

Post

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...

 

table 1 

field- item's monetary amount

field- Item's purchase #

 

table 2

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.  

 

Thank you

Outcomes