3 Replies Latest reply on Aug 31, 2011 4:13 PM by philmodjunk

    Auto complete look up

    ZandriBanks

      Title

      Auto complete look up

      Post

      I have 2 layouts comprising of the same fields. Layout 1 is the actual inventory layout records & Layout 2 is a layout used for signing stock out of the inventory. Is there a way of allowing users to complete a specific field in Layout 2 & have that field call in / look up the rest of the enrty details. eg:User enters a barcode number & the corrosponding details are auto-entered. Any help would be fantastic. Thanks! 

        • 1. Re: Auto complete look up
          philmodjunk

          There are two basic approaches depending on whether it is better to physcially copy the data from one table to another (Tables, not layouts) or to just add fields from the "look up" table to the other table's layout.

          See this link for a discussion of both methods:  Auto Fill

          • 2. Re: Auto complete look up
            ZandriBanks

            Is it possible to have this occur if I am using layouts for both and not tables? 

            • 3. Re: Auto complete look up
              philmodjunk

              Layouts and tables are two very different things even though the name of a table and a layout is often the same.

              Every layout refers to a table. Unless both layouts refer to the same table in Show Records From in layout setup, moving data from one layout to another actually requires moving the data from a record in one table to a record in the other. That's one of the two options discussed in that link. The other option avoids moving any data, but instead just uses the fields from the related table to display the data.