1 Reply Latest reply on Apr 13, 2009 9:10 AM by philmodjunk

    Best way to search another table and return?



      Best way to search another table and return?




      I looked for this answer around, searched the forums here and couldn't find a concrete "best" practice for this.


      I'm in an invoice layout with customer information on one tab, that comes from another table. On entering a new record I'd like to allow the user to search for an existing customer and return/fill out the customer fields after the search, on the original invoice layout if this is possible.


      I'm assuming on the invoice layout I can use the customer::* fields but how to let the user do the search and return to fill those fields is eluding me.


      I can't use a custom dialog because they may need to search on more than the 3 field limit of the dialog. Any help would be appreciated.