I looked in the HELP and believe found what I needed. Since the detail section has multiple rows and I want to "tack on" the model information from all rows in the detail section into a variable memo on the Header, I used this:
SELECT (LISTOF(DISTINCT Model#)) INTO + vModelList INDIC IvModelList FROM tOrderShip + WHERE Control# = .vControl That gave me the info I want on the model#. Can I use the LISTOF command on two columns at once? SELECT (LISTOF(Model#,Quantity)) INTO + vModelList INDIC IvModelList + vQtyList INDIC IvQtyList FROM tOrderShip + WHERE Control# = .vControl I noticed the SRPL command is used to change the outcome. I want the list to show Model#-Quantity, Model#-Quantity etc. Jim -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of A. Razzak Memon Sent: Tuesday, November 17, 2009 2:54 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: GO TO SECOND TABLE At 03:11 PM 11/17/2009, Jim Belisle wrote: >Thanks Razzak. I thought that was the way to go and it worked very >well. I now want to know what command I will use to do the following: > >When I first enter the form, I want to get the information from specific >fields (Model & Pieces) from the detail section and put them into >variables. The purpose is to add them to a note field on the Header. >The final results will be like this: SB16-1, 8J2GW-2 etc. I realize I >will have to change the pieces from Integer to text. What commands would >I need for this? Good! Now what you need is to use the GETPROPERTY <CompID> TEXTVALUE 'varname' command to dynamically capture the field value, analyze the condition and then handle everything accordingly. -- Example 1: IF varname = 'SB16-1' THEN -- conditional stuff here .. ENDIF -- Example 2: IF varname IN (SB16-1,8J2GW-2) THEN -- conditional stuff here .. ENDIF You can also use the Form Variable as Expression based on a column which will always return the correct value on a focused control of selected row. Very Best R:egards, Razzak.
