Looking for a tip here. PO form shows vendor profile billing terms (ex: Net 30) in a variable edit field (read only). Terms billing DB LookUpComboBox. LookUp settings sort order by TID (integer) col, hard coded by most often selected by the user.
However, I now want to display the vendor's profile billing terms by default in the LoopUpComboBox, yet still allow user to select another billing term via this combobox. Other than creating a view prior to form entry, etc... I'm not sure how to accomplish this, but I know readers of this list have some ideas which I appreciate! Thanks, Brad Davidson -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of MikeB Sent: Monday, November 22, 2004 3:14 PM To: RBG7-L Mailing List Subject: [RBG7-L] - RE: CHKBOX funtionality in Forms >select statement? If I do a concatenation of two columns it returns the >value of the concatenation but I would prefer to have the value of only When I want this functionality from a listbox, I do something like this: Load the Listbox with an Expression, either from lookup or Load_From_File, but make the expression: ((ljs(TheValueToDisplayInTheListBox,30)) +',' + TheReturnValue) Where the LJS value is wider than the listbox display, then when you get the value selected, just do a (SSUB(WhateverTheValueIs,2)) and you will have the return value...
