how do i use a list of values in a 6i form

[bookouri]

I have a form to issue equipment. One data block is the equipment table, the issue_equipment transactions are a data block linked by the equipment_id_number to the equipment table and by the user_id to the user table. I want to put a drop down text box on the issue block to assign the equipment to a user. I want the drop down to display the user name from the user table, but I need it to enter the user_id into the issue_equipment table rather than the user name. Im sorry I cant describe this in more simple terms.. basically I need to have a drop down that shows me a list of names so the user can pick the right individual, but the drop down has to plug the user_id NOT the name into the target table.

thanks in advance for any help....

 

[JamesGordon]

Create a record group with the userid and name.
Create a LOV which uses the record group.
Go to the column mapping properties dialog.
The return item field displays where the value of the LOV column will be placed, ensre that the ID goes to the userid column and that the user name has the return item field blank.

 

[bookouri]

Thanks, I tried that and it worked great...