Victor, now, that's an idea... I'm going to try it and report back. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Victor Timmons Sent: Thursday, July 01, 2004 12:16 PM To: RBG7-L Mailing List Subject: [RBG7-L] - RE: Scrolling Region and DB Lookup ComboBox
Why not just create a form var that has the description and put it in the region next to the ID '22'. vBedTypeDesc = BedTypeDesc IN BedType WHERE BedTypeID = BedTypeID --------------------- |22| |Flat Bed| --------------------- On 1 Jul 2004 at 12:05, Claudine Robbins wrote: > 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 > > Victor Timmons Tiz's Door Sales, Inc 425-258-2391
