3 Replies Latest reply on Aug 8, 2011 12:31 PM by philmodjunk

    Many-to_Many Join Table

    FM_Rookie

      Title

      Many-to_Many Join Table & Autocomplete

      Post

      I'm a newbie, so please speak slow.

      I have a 3-way, Many-to-Many  join table. In either a layout or a portal, I want to be able to do a drop-down list with  auto-complete in the "Name" field from a related table (I have the  relationships correct, I believe), but have it also populate the _kf  with the _kp associated with that name.  I can get it to use list with  the _kp + name for the list, but then auto-complete doesn't work & the list is  WAY too long for practical use.  When I use just the name auto-complete  works, but all it will do is put that name in a field, not the _kp in  the _kf.  If the name is changed in the _kp table, it will not be  reflected in the join table.  Perhaps there is another method, but this  would be simplest for the user.

      Any help or ideas would be greatly appreciated.
      Russ

      screenshot_01.jpg