AnsweredAssumed Answered

FileMaker 11 and SQL importing

Question asked by jtoland on Feb 21, 2012
Latest reply on Feb 23, 2012 by LSNOVER

Maybe this is a common understanding, but we are finding that when we add a SQL table to our solution, that all the data comes across unsorted, and not based on the view we setup in SQL. IS there any way around this? Or this is common behavior when dealing with SQL.


To get around this we created a concatenated key field using last name/firstname/userID. This seems to make the data com3e across alphabetized, but does not always product expected results.


Any Ideas? Plugins?


James Toland

Contract FileMaker Software Developer, Information Technology

Center for Elders' Independence

510 17th Street, Suite 400

Oakland, CA 94612

Phone: (510) 318-7130

Cell: (510) 432-7470