> Thanks, however I tried the temp table thing already > and that takes too > long also. Its creating a temp table then inserting > non-duplicate rows > from a table that has 14,000 records in it and that > was too painfull > too
If you are trying to dedup a 14K record table everytime you load the combo box, you may have a legitimately slow operation on your hands. Certainly, the combo box is unlikely to load _faster_ than the time it would take to select the records into a temp table (the problem is the combo boxes are often much _slower_ than a regular SELECT). But here's something you can try. Create a compound index on your table including all the columns that appear in the combo box and that have to be unique. If you do that, R:Base _should_ perform and index-only retrieval for the combo box, and that will have performed the deduplication for you: CREATE UNIQUE INDEX ON YourTable(YourCol1, YourCol2, YourCol3) -- Larry
