Based upon what you are stating, I would use arrays from external source, build arrays from 4D and display
If you do it the other way display fields from 4D, you would keep shadow arrays to fill variables with and yes because you have shadow arrays you can sort on this columns. I do that now in a variety of places I also do not know which approach (array based/ field based) or ALP would be best for your scenario it depends upon many factors Both will do the job for you. I use list boxes and ALP areas in dos, it just depends upon client and need Regards Chuck ------------------------------------------------------------------------------------------------ Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617) 232-1064 mailto:cjmiller<AT SIGN>informed-solutions.com Brookline, MA 02446 USA Registered 4D Developer Providers of 4D and Sybase connectivity http://www.informed-solutions.com ------------------------------------------------------------------------------------------------ > On Aug 31, 2016, at 3:29 PM, Alan Tilson <alantil...@gmail.com> wrote: > > Chuck, > So you could do one Find In Array to get a row number in the synced arrays > and then use that row number to set a series of variables, one for each > field from the external source. Something like that? But you wouldn't be > able to sort based upon those columns, correct? > John, > Is this something like what you are doing? How do you handle sorting? > Thanks to you both! > Alan ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **********************************************************************