RBWin 6.5+ I use the following command to provide a pop-up for selecting a column on which to do a search. CHOOSE vcols FROM #VALUES FOR sys_comment, sys_column_id + FROM sys_columns + WHERE sys_table_id = .vtblid CAPTION 'Select A Search Field' I set up, prior to entering the command file where this line is located, so that this command file can be used for any table. It works fine when sys_table_id specifies a table containing all of the columns I need to select from. However, I have at least one table (at this time and perhaps more later on) that does not contain a column I wish to display in the pop-up. If I define a view combining the primary table with another table that does contain the column I wish to display in the pop-up, there are no sys_comments for a view nor am I able to edit sys_comments to add the column descriptions for the pop-up. Also, if I decide I want to edit the result the search yields rather than just view it, I can't edit a multi-table view. 1) Is there anyway to get sys_comments for columns in a view to display? or 2) Do I have to do something like define a temporary table containing all of the columns I want to display? and 3) If I must do (2), are there going to be any repercussions having a form defined on a temporary table (if that is even possible) when that table disappears? and 4) Would I be able to edit the search resulting from a temporary table if I elect to edit rather than just view the results of my search? Jim Take a cruise. Click on our Web sites - USS COOLBAUGH DE-217 Web Site - http://members.nbci.com/eag128 USNTC Bainbridge Web Site - http://members.nbci.com/Sailor6804/Bainbridge.html
