[[https://www.revelation.com/|Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community]]


==== Removing multiple values in a popup (OpenInsight Specific) ====
=== At 10 JAN 2000 12:26:21PM Bill Goodrich wrote: ===
 
{{tag>"OpenInsight Specific"}}
 
<QUOTE>
We are migrating an AREV application to OpenInsight.  



In the contacts section of our database, I would like to create a popup using data in the column STATE.  The source is SELECT ROWS from Table.  The table is CONTACT.  The column is STATE.  What do I put in the Selection Criteria, to limit the data in the popup to non-null, two letter, unique values?  It the Selection Criteria the proper place to modify the data or do I have to process the data in another area?



Right now we have BY STATE in the selection criteria, and this lists a STATE for each row sorted alphebetacially.  (ie- null to WY)



Thanks:



Bill Goodrich 

http://www.Goodrich_B@CorningHospital.com
</QUOTE>

[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=NONWORKS_READ&SUMMARY=1&KEY=6D5ED62E8573937E85256862005FCC1E|View this thread on the  forum...]]