One of the really nice things about redesigning something after 15 years is that it gives me an oppurtunity to correct problems that have bugged me for a long time! And, this is another one. I have a table with a column that contains 2 letter codes. There can be many rows that will contain the same code. I'd like to load another table with 1 instance of each of the codes that appear in the first table. This is a one shot deal; just to get a new table up and running. Is there a function that would help me with this? Seems to me that I remember something about one. thanks, Lin
