Making a search based on a search
I've been trying to wrap my head around this, but Im not very familiar with FM scripting.
What i am trying to do is to first find a set of unprocessed orders that is older than 2 days, make an array of the companies from that search, and then make a new set with all unprocessed orders from all of those companies.
I dont know if I made myself clear, but basically I want a recordset of all orders from companies that has unprocessed orders that are older than 2 days, and then also include newer orders from those companies if they have one.
I was thinking of :
- making the search on all unprocessed orders older than 2 days
- looping the search adding companyID to an array
- then make a new search on all unprocessed orders having companyID in that array.
But im not sure (beyond making the seach) on how to do this.
Is there even possible to make an array in Filemaker?
I come from PHP/MySQL..