Frank: This is what you do: In the Pop-up Menus window Table/View Name: select the table from where you want the values to come from Pop-up type: select whether you want to display a single column, more that one column or an expression. If you select single column, the return column will be displayed by default; if you select multi column, you will be prompted to select more than one column. Column returned: the column, which value you want in the field. The column that is returned does not have to be the same as the column(s) displayed. For example you may want to display an employee last name and first name but you want to return the SSN; so, when you click on the employee name in the pop up, the Social security number for that employee will be displayed in the DBEdit field. Menu Caption: Whatever you want to display above the values Number of Lines: How many lines you want to display If you want to display unique values for a column, then, on the big box under WHERE Clause type: GROUP BY your_column_name Notice that there is no "WHERE" typed. For example if you want to display the state code from a file in which the state_code is repeated and you want to display just one occurrence of each, the you would type: GROUP BY state_code This will display just one line for each state_code and will also sort the data by state_code. I hope this is what you are looking for; if not, let us know and we will make sure that you get your pop-up going... 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 Fran Yount Sent: Thursday, February 03, 2005 6:38 PM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: DBedit box /popup menu I do not know why this has me so confused but it does. So what would I put in the pop up type , menu values and where clause to get the values to come up distinct? Fran -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of Dawn Oakes Sent: Thursday, February 03, 2005 5:03 PM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: DBedit box /popup menu Well I'll be a.... I've always created a view and based my popup on the view. It didn't occur to me until just now to do a group by right in the popup where clause. I don't know why, I guess I just got used to doing that. ...something new everyday -----Original Message----- From: Albert Berry [mailto:[EMAIL PROTECTED] Sent: Thursday, February 03, 2005 5:44 PM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: DBedit box /popup menu Check you SELECT syntax, and add the GROUP BY clause to your choose popup WHERE <if any> GROUP BY <column> ORDER BY <if different than the group by> --- Fran Yount <[EMAIL PROTECTED]> wrote: > I am trying to figure out how to write the expression in the Dbedit > popup menu to show distinct values. I could write and "eep" but I > would prefer not to. I am new to the Rbase developer's page so any > help or direction would be greatly appreciated. > > Sincerely, > > Fran Yount > [EMAIL PROTECTED] > > ===== Albert Berry Management Consultant RR2 - 1252 Ponderosa Drive Sparwood BC, V0B 2G2 Canada (250) 425-5806 (250) 425-7259 (708) 575-3952 (fax) [EMAIL PROTECTED]
