2 Replies Latest reply on Dec 5, 2011 10:02 AM by philmodjunk

    Matching value list, beginning to doubt myself

    ilyaDevers

      Title

      Matching value list, beginning to doubt myself

      Post

      Hi,

      After a long time away from Filemaker I am now evaluating it for a project I have. I used to build solutions where you would use a script (move to view, perform find, wait for the user to select a record, copy the value of interest, insert it in another field, revert back to the original view).

       

      However in 11 it seems I can just work with Value lists to achieve looking up related values. However it is driving me crazy. I have followed the example of the Menu, Items, Orders and have tuned it to normalize the Menu by adding an Items table, working with primay ID's. So far so good. But my own experiment I cannot pull off..

      For simplicity i have thought of a rather normal information field. A company. A company has departments. An employee belongs to a company, and and employee belongs to a department.

       

      Here are my tables:

      company -< department

      company -< employee

      department -< employee

       

      To model this in the relationship graph I have one extra occurence of the company table (company_2) for the relationship with the employee.

       

      Each table has its own id fiels (unique number, auto generated). And the relationsship uses employee::company_id>-company::id schema..

      On the employee layout I add a pop-up menu for the company. So far so good. It shows the companie names, and I select the company_id

      Then I add a second pop-up menu with the departments. I tell the value list to "include only related values starting from : "

      Whatever table I select, the only constant is that the pop-up menu shows : <no values defined>.

       

      I have simplified and simplified to see what is going on, but cannot figure it out...

      Please help anybody, as I am going crazy! What am I doing wrong?

       

       

       

       

      Screen_Shot_2011-12-04_at_17.06.00.png