13 Replies Latest reply on Apr 7, 2011 4:05 PM by philmodjunk

    Problem with popup Menu



      Problem with popup Menu



      probably a simple error so apologies up front

      Have created a table of names, then created a popup menu on a different layout referencing the table of names. It displays the popup list but once you pick a name it replaces the name when you reference it again with a question mark - ? and puts the question mark in the table of names. It only replaces one record usually the first one picked.

      It also mimics this error in a drop down box, so it would seem to me it is not a data or field issue more to do with relationships or something.

      Any ideas?



        • 1. Re: Problem with popup Menu

          Do both layouts refer to the same table or different tables?

          Assuming different tables for each layout, the field formatted as a pop up menu should be a field from the 2nd table, not the table of names.

          Don't know why you are getting a ? here. If you place a copy of this field next to the pop up menu, but format it as an edit box, does it also show the "?" ? What do you see when you click or tab into the edit box?

          • 2. Re: Problem with popup Menu


            the layout is attached to tblschoolList and the popup menu is also attached to tblschoolList. The fields on the layout are attached to tblSchools.

            The popup menu is doing the job and refreshing the form with correct data it only has an issue with one record (not a specific one / whatever one selected)

            Yes it was there for a while, the ? appears in the tblschoolsList and when I place a field on the form it shows up there. And then the whole record just disappeared.

            Kind of an xFiles moment

            Thanks in advance



            • 3. Re: Problem with popup Menu

              is tbleSchoolList the only table in your database? Or do you have a separate table for the menu's value list? Keep in mind that layouts and tables are different things here.

              Sometimes a question mark where there should be data indicates a problem with a field's index and the index is what a table base value list like this uses to produce the list of values. You can try rebuilding the field's index to see if it makes any difference.

              To rebuild the index of a single field,

              1. open Manage | Database | Fields and double click the field
              2. Use either the storage tab or the storage options button to turn off indexing.
              3. Exit Manage | Database, then return and turn indexing back on.


              You can also rebuild all your file's indexes by importing all the data into an empty copy (clone) of your file.

              If you have FileMaker 11, you can use Advanced Recovery options to rebuild your file's indexes:

              With the file closed, select Recover from the File Menu.

              Select "Use advanced Options"

              Select only: "Copy File Blocks as-is" and "Rebuild Field Indexes Now".

              • 4. Re: Problem with popup Menu

                tblSchoolList is a table for the menu and tblSchools is the table to be either updated or display of data. tblSchoolList is a direct copy of tblSchools. In the relationships I have created a join between a unique field destNo mirrored in both.

                Do I still go with the rebuild

                • 5. Re: Problem with popup Menu

                  Don't know. It can't hurt.

                  How exactly did you do this?  "tblSchoolList is a direct copy of tblSchools"

                  I can think of several ways to read that and they don't all have the same results. You might have two boxes on Manage | Database | Relationships, but only one table listed on the tables tab. Or you might have two tables listed in the tables tab.

                  • 6. Re: Problem with popup Menu

                    Duplicated it.

                    both tables listed in the tables tab and both in relationships

                    • 7. Re: Problem with popup Menu

                      Ok, then let's check these details and see if anything I list differs from what you have:

                      The value list is defined to list names from tblSchoolList.

                      On a layout to TblSchools, you have a text field defined in TblSchools formatted as a Pop up Menu that uses this value list.

                      Make sure that this field is from tblSchools and not from tblSchoolList. You may need to enter layout mode and double click it to check.

                      If you used a field from tbleSchoolList instead of tblSchools, this would explain why selecting a name in the pop up changes a name in tblSchoolList. It doesn't explain the ? you saw, but first things first.

                      • 8. Re: Problem with popup Menu


                        I think I have got it.

                        the layout is correct as you stated, with data from tblschools

                        The popup menu was displaying data from schoolsList and value field from schoolList.

                        This meant that the first school selected was replaced with a ? and data was not refreshed in the layout based on the selection from the popup menu.

                        What I did was change 

                        the popup menu to display data from tblSchools and leave the value field pointing to schoolList.

                        It works perfectly.

                        Was that the right thing to do??



                        • 9. Re: Problem with popup Menu

                          What table does this layout refer to in Layout setup... (Show records from)?

                          The menu's field and the layout should refer to the same table.

                          • 10. Re: Problem with popup Menu


                            both menu field and layout are referring to tblSchools

                            • 11. Re: Problem with popup Menu

                              Then you should be all set.

                              • 12. Re: Problem with popup Menu

                                Just noticed,

                                the pop up menu is working correctly and changing the related name field but it is not updating the rest of the layout (like address fields). Made a new layout with a portal style and same issue

                                Any ideas

                                • 13. Re: Problem with popup Menu

                                  There are two basic ways to link your tables so that selecting a value causes data in other fields on the layout to appear. This thread describes both approaches. The consequences of each choice are different so read and compare the options carefully.

                                  Auto Fill