I am close but my at filter is returning nothing to filter against. It is either a syntax problem or you can't use <@Filter> aginst two arrays. ---- Dan Stein <[EMAIL PROTECTED]> wrote: > > I need suggestions for the best way to do this. > > Stored as a custom scope I have a 26 column array with 869 rows that > contains a unique unit ID > > After a complex series of searches on other tables I have a request scope > array that contains the unit id's which is going to be a one column array > > I want to filter the 1st array in a way that the new array only has the unit > id's from the complex search and come up with a new request scope 26 column > array. > > How can I best do that > > To keep it clear > > The 26 column array is called villa$units > The 1 column array is called request$adv_search > > Dan > > -- > Dan Stein > FileMaker 7 Certified Developer > Digital Software Solutions > 799 Evergreen Circle > Telford PA 18969 > Land: 215-799-0192 > Cell: 610-256-2843 > Fax 413-410-9682 > FMP, WiTango, EDI,SQL 2000, MySQL, CWP > [EMAIL PROTECTED] > www.dss-db.com > > > "When you are born, you cry and those who love you rejoice. And if you > live your life as you should, when you die, you rejoice and those who > love you cry." > > ________________________________________________________________________ > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf > >
-- Dan Stein MSN Certified FileMaker 7 Developer Digital Software Solution, LLC 799 Evergreen Circle 215-799-0192 610-256-2843 ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
