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.
