3 Replies Latest reply on Mar 15, 2013 12:07 PM by philmodjunk

    Pop-up list not populating

    AmberEdwards_1

      Title

      Pop-up list not populating

      Post

           I have two tables, one that has employee names (Employee) and one that has tasks to be completed (Basic Tasks).  One Employee, there is a field for first_name, last_ name and a calculation field (Name) to combine them (first_name & " " & last_name) They are linked by a field called ID (in the employee table it is a serial number). On the employee table it is EmployeeID and on the Basic Tasks table it is BTID.

           I am trying to place a pop-up menu on the Basic Tasks layout  to select employee name. I put a field into Basic tasks for the linked ID field (BTID).  Then I made a value list that pulled the EmployeeID first, then displayed the Name field.  I also selected the show second value only.  When I do this, in the pop-up menu I get a little check box and a ?.  Sometimes just a ?.

           I have tried also a drop-down list and get the same results. If I allow both values to be shown (in a drop-down list), it functions correctly.

           This seems like I am doing something simple but I can not figure it out.  Thanks

        • 1. Re: Pop-up list not populating
          philmodjunk

               As I understand it, this is the relationship:

               Employee----<Tasks

               Employee::EmployeeID = Basic Tasks::BTID

               The name of your ID field in Basic Tasks raises questions:

               BTID would seem to stand for "BasicTasksID", but this field does not identify the Task, It identifies the Employee. FileMaker won't care about the names, but the confusing names may indicate a confusion in how you are using the field. Have you specified any field options for BTID? If you have defined it to auto-enter a serial number just as you have for EmployeeID, this setting should be removed. It shoud be a simple number field.

               More typically, you'd name this field EmployeeID to show that it stores the Employee ID and then you'd add a BTID field to your layout, set up as an auto-entered serial number, but NOT linked to EmployeeID in a relationship as field to use to uniquely identify each record in Basic Tasks.

          • 2. Re: Pop-up list not populating
            AmberEdwards_1

            PhilModJunk -

            The field is actually BTEID (Basic Tasks Employee ID).  I left out a letter.  I use this naming style so that I can tell which is the parent and which is the child easily.  Its an old habit that I have from using VBA and I found that if I labeled the fields the same in different tables it gets confusing.

            The only field (in the relationship) that that has an auto-enter serial is the EmployeeID. So the relationship goes from EmployeeID (Employee Table) To BTEID (Basic Tasks Table) .  I do have an auto-enter serial number in the Basic tasks table, which is correctly labeled as BTID but this is not in the relationship between the two tables.

            • 3. Re: Pop-up list not populating
              philmodjunk

                   That was the most obvious potential issue. The next step requires more sleuthing. Bascially, you'll need to reveiw the set up for your layout, the value list and the field's definition in Manage | Database | Fields.

                   ? is FileMaker's way of saying "I can't display this". In calculation fields, this can be the result of divide by zero or a recursive expression without an branch to end the recursion. In fields of types number or date, it can be due to a field that is too narrow to fully display the data.

                   But a check box with a question mark seems very odd. Never saw that one in over 10 years of FileMaker stuff.