7 Replies Latest reply on May 18, 2016 12:19 PM by farmer4h

    Lookup field does not update in first row of portal but works fine in subsequent rows... driving me crazy.  What should I be looking for?

    farmer4h

      When you look at the screen capture you see the score for the first portal row is empty... the field is empty, I looked at the table.  There is a lot going on in the background:  Dwindling value list for Place.  The unidentified field on the left is a list of all the places already used in the portal.  It updates as places are entered and the value list dwindles appropriately.  Used Guy Stevens tutorial to make the dwindling value list:

       

      https://www.youtube.com/watch?v=RqxMJmjRvCw&feature=youtu.be

       

      The look up is dependent on a table called "score" and there is a relationship with "type" and "Discipline" so it looks up the correct score.

       

      Anybody got any ideas????  Anybody got the time to assist a newbie?

      2016-05-18_1010.png