Javier, Kayza, Larry, Victor: I had a one-track mind on not having the integer value show up on my form. I used your idea to use a variable for the text value but I obtained it from a choose command launched from the static text, then I assigned the integer value based on the variable.
Instead of: Truck Type (text label) integer value (dbedit with a pop-up returning truck_type) variable (variable label vtruckdesc) and the assignment vtruckdesc = truck_type_desc in d_truck_types where truck_type = truck_type I have: Truck Type (text label with launch of choose command to return vtruckdesc) and variable (variable label vtruckdesc) and the assignment truck_type = truck_type in d_truck_types where truck_type_desc = .vtruckdesc Now to work on the edit using form.... Thanks everyone! -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kayza Kleinman Sent: Thursday, July 01, 2004 12:48 PM To: RBG7-L Mailing List Subject: [RBG7-L] - RE: Scrolling Region and DB Lookup ComboBox So, use a variable field to show "flat bed" 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 > > > > -- Kayza Kleinman Director, Nonprofit Helpdesk Jewish Community Council of Greater Coney Island, Inc. 3001 West 37th Street Brooklyn, NY 11224 Tel. 718 449-5000 Fax 718 946-8240 [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> www.nphd.org <http://www.nonprofithelpdesk.org/> "Putting Technology to Work For You"
