1 Reply Latest reply on Oct 3, 2012 8:03 PM by DavidJondreau

    Pop-up Menus can show additional incorrect data


      Since 2004, when FileMaker Pro 7 was released, we have been given the facility to display data from just the second column in a 'Pop-Up' menu.  However, in making this change the way in which a normal two column Pop-up menu works has been compromised.


      If the data in the first column of the pop-up is of different widths, the field on the layout that shows this data has to be extended, so as to be able to display the widest entry. When the developer extends the field in this way, particulary if the first column entry is very short, data from the second column slides across from the right and shows in the field of the first column. This does not affect 'Drop-Down' menus.


      This may seem mundain, but the result is that data in the first field has the start of data in the second column concatenated onto it.  This means that the data in the first field appears corrupted becuse it is showing some data from the second column, and that is NOT what is stored in the first field.


      For example, if the data in the first field is a short part number (ABC), then the result displayed includes the start of the second column, which might be a description (ABC Torque W..).


      For a database system to show inaccurate data is inadmissable, but to ignore this problem for nearly ten years is inexcusable.


      Please be assured that versions of FileMaker Pro up to and including version 6.0 handled this issue properly, without showing any details from the second column, but every versions since then has suffered from this problem.  I have mentioned this problem previously, but my requests have been ignored.

        • 1. Re: Pop-up Menus can show additional incorrect data

          This feature is working correctly as documented. "Also display results from the second field" is pretty unambigous. You're choosing to make your fields smaller than the fill width to display the value, but that's not FileMaker's fault.

          One way to get the result you want is to have a two fields stacked on top of each other. One that allows entry in Browse mode with the value list as you have it but with conditional formatting that sets the font size to 500 px when there's a value. The other field would be the exact same field, but not be enterable in Browse mode, and not have a value list attached.