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