2 Replies Latest reply on Jul 6, 2012 8:59 PM by TC

    Finding records


      I have a layout that has a dropdown box that dymically uses values from a field - That works

      I have a portal that displays associated records from the value picked from the dropdown box - that works


      The problem is that the value chosen in the dropdown box also changes the field value of the active record of the table used in the dropdown box (usually the first record)


      So I have a table of routes (A, B, C) used as the lookup values in the dropdown box. and

      Customers 1, 2, 3 for route A

      Customers 4, 5, 6 for route B

      and Customers 7, 8, 9 for route C


      If I choose Route A, Customers 1, 2, 3 are displayed in the portal. If the active record is A, then A is changed to A, but if the active record is B, then B is changed to A


      What am I doing wrong or can this be done this way. If not, any suggestions