2 Replies Latest reply on Mar 8, 2016 7:58 AM by canmac

    Value Lists Issues


      I have been using FM since version 3, however, don't mistake duration for me being a master programmer.


      Recently we upgraded from version 12 to 14, and yes we had to go purchase a dedicated server.  The reason was to jump on the web with our projects/crm databases for our employees to make easier to keep up todate on the road.


      I have had a nightmare trying to figure a value list problem.  These lists have run for years with no problems.

      However, with version 14 utilizing my Projects database, with the project # field active, the list is to return a project # (value 1) and the project name (value 2) is the sort field, previously you were able to type the first couple letters of value 2 and it would narrow in on the correct project number (value 1) you want to bring in.  Now if you try typing it will not affect value 2 it thinks it is still on value 1 not recognizing value 2.  So to make this work with version 14, I am having to hide (value 1) in order to search/type by project name.

      Now here is the real kicker, i have a version 12 running and it still can access the new server and the value list operates as expected????


      I have the Server Software 14.04 on a new server running 64bit.

      I found to get the email to work properly with my outlook I am running the FM x86 14.04 32bit client version.

      I have a hard time believing that there is issues since it is running on my term server with FM12 just fine.


      I am thinking there has to be a button somewhere to turn some feature on/off.

      I have spend the last 2 weeks sending files back and forth to FM Tech Support and they say they work fine on their end.

      Has anyone run into this with any of their recent software upgrades.

      Any feedback would be greatly appreciated.


        • 1. Re: Value Lists Issues

          I'm assuming your server and client are on Windows?  What version of Windows is your client on?  Does the problem go away if you try it 64 bit FileMaker Pro?  And while I can feel the frustration, I would probably solve such a situation with a popover and virtual list.  I think you are right in expecting it to work like it did in 12, but if it doesn't, about all you can do is submit a bug request and try to solve it in a different way.  Does this work on some computer and not other ones or does it not work on any of them for you?  If so, if you can describe the difference in the computers.  Or can you create a sample file with just this layout and table/fields (no data) and duplicate the behavior and upload it here for us to try?  If we can't figure it out here in the discussions, you might want to look for a FileMaker developer in your area to help out.  FileMaker Consultants, Data Consultants, Database Consultants

          • 2. Re: Value Lists Issues

            Thank you for taking a look at my post.

            I have stripped the file down removing all links and relationships with only 12 records.  Even using the file as a stand-alone the list will work typing in value 2 on version 12 and not with 14 (32or64) regardless of which computer which is consistent accross systems.