Thanks, Karen, yes - but that's the easy way! I was trying to make life difficult for myself and lose IdNum fields.
I've got lots of forms that are perfectly good and have both a text description and its related IdNum where the user tabs from IdNum field to IdNum field. However, the IdNum is useless as far as the user is concerned and I have been trying to remove wasted data from my forms for reasons both of space and aesthetics. I know I can (almost) hide the IdNum fields but tabbing from text field to text field looks so much nicer. As it happens, I have found a solution today but it's not perfect: by using 2 forms I can create a temp view from the first form that is used by the combo-box on the second form. The only thing wrong with it is the slight flicker between the forms. With a bit more effort I can probably display the second form positioned over a blank area on the first form which might be more acceptable. Either way, the overall effect looks much better than dialog boxes and pop-up menus that seem "out of character" with Windows look and feel - and I had to be almost dragged screaming into RBWin!! Thanks & regards, Alastair. ----- Original Message ----- From: "tellef" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Wednesday, February 05, 2003 4:26 PM Subject: [RBASE-L] - Re: A couple of Form how-to questions Alastair: Unless I'm reading your example wrong, can't you locate the integer column on your form (instead of the varaible text field), have the combo box go to your lookup table, have the 'load combo box with values from column' set to the text description, have the 'return value from column' set to the idnumber column. Your combo box would then show the descriptions as you like, but the idnumber is stored in the column. Karen > For example, say that 2 rows in the form table integer column are: 100 & 200 > (along with other data); > and the pop-up menu returns Fred, Joe & Mike with idnums 100, 150 & 200 > respectively > On entry to row 1 on the form the text is shown as Fred. > The use then selects Joe from the pop-up which is displayed in the field and > then goes to the next row.
