Claudine: The pop-up will return whichever field you tell it to return; it can either return the 22 or the 'flat bed', it really depend to what columns the value is being returned. If your column receives the truck number (most likely) then create a look-up variable in the form next to it and it will display the description: WHERE: truck_ type = 22 truck_desc = 'flat bed' truck_type_table - table that contains the truck description Variable Vtruck_desc = truck_desc IN truck_type_table WHERE truck_type = truck_type This is the way I usually display description for columns in a normalized database. Javier,
Javier Valencia, PE President Valencia Technology Group, L.L.C. 14315 S. Twilight Ln, Suite #14 Olathe, Kansas 66062-4578 Office (913)829-0888 Fax (913)649-2904 Cell (913)915-3137 ================================================ Attention: The information contained in this message and or attachments is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from all system and destroy all copies. ====================================================== -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Claudine Robbins Sent: Thursday, July 01, 2004 12:06 PM To: RBG7-L Mailing List Subject: [RBG7-L] - RE: Scrolling Region and DB Lookup ComboBox Javier, Unless you know something I don't, a pop-up can show '22 - flat bed' and when clicked will return 22. That means that, when the user moves on to the next field, on the screen, it will say '22' not 'flat bed'... -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Javier Valencia Sent: Thursday, July 01, 2004 11:54 AM To: RBG7-L Mailing List Subject: [RBG7-L] - RE: Scrolling Region and DB Lookup ComboBox Claudine: Why don't you just use a pop-up box for the field in the scrolling region? You can display multiple columns such as truck number and description and then specify which column will be returned. You can use the WHERE clause to restrict the number of records that you display and there are many ways to format the box as well. Javier, Javier Valencia, PE President Valencia Technology Group, L.L.C. 14315 S. Twilight Ln, Suite #14 Olathe, Kansas 66062-4578 Office (913)829-0888 Fax (913)649-2904 Cell (913)915-3137 ================================================ Attention: The information contained in this message and or attachments is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from all system and destroy all copies. ====================================================== -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Claudine Robbins Sent: Thursday, July 01, 2004 11:47 AM To: RBG7-L Mailing List Subject: [RBG7-L] - Scrolling Region and DB Lookup ComboBox I have a scrolling region which will have 45 or so objects in a detail table in a one-to-many form. For three fields, I need the functionality of a DB Lookup ComboBox, populate and pick from a text field in a lookup table and return an integer to the underlying table's field. I successfully use this in the header table. For example, one field is truck_type, an integer, the truck_type_desc is in another table. Truck_type might be '22' and the corresponding description is 'flat bed'. I want to click on 'flat bed' and have it return '22'. I cannot place a DB Lookup ComboBox on a scrolling region. I can place a Variable Lookup ComboBox but it doesn't show up after I save the form so I assume it's also not allowed (it doesn't generate any error messages). Is there another way to do this? Any suggestion to get me going again? TIA
