1 Reply Latest reply on Sep 24, 2014 1:04 PM by philmodjunk

    Need help with lengthy dropdown list

    BobRusch

      Title

      Need help with lengthy dropdown list

      Post

      I am a pretty new user, and now developing my first application.  Things are going well, but I am a little stumped with a dropdown list problem.

      My application involves making kits.  These are boxes that are sent to customers with various items put inside them.  In my kit layout, there is a portal for the kit line items, similar to detail line items  on an invoice layout.

      The idea is to add items to the kit through the portal.  I set up a dropdown list where I can pick the part number of the detail line item, and enter a quantity.

       The line items in the portal use a foreign key (_fkItemId ) that is related to  the Item file (__pkItemId).  I have approximately 35,000 items in the Item file.  My dropdown box works fine, but since the data type in the relationship is a number, I cannot use Auto Complete to type in partial Item Numbers.  This means that I must scroll through to find the right item number, which is time consuming given that there are 35,000 items.

      I would like to be able to either have an autocomplete function as I type, or hit a lookup button that will allow me find the product and then populate the portal row based on my lookup.

      Thank you!

       

       

      ScreenShot559.jpg