We have a customer database that allows multiple address for a client. ie Mailing, billing, vacation, etc. We have an address hierarchy to follow. I would like to have CR looking into the address type field and choose ONE address from a list and that address be the highest on the hierarchy table. For example, if a "bi" exists, then use that address, if not move down to the "ma" address, if it exists us it, if not, the move down to the "bu" and so on and so on and if "null" use the default address on the account. Thanks in advance for your help.

Chris

Thank you so much for the reply!   
All the address are in a single table - UCRADDR
Each address type is on its own line.
Each customer can have more than one line.

CUST_CODE    ADD_TYPE     CITY           ACCT_STATUS
2419           BI        SPOKANE            A
2420           BI        CHICAGO            I
2421           BI        BRADENTON          A
2421           MA        MIAMI              A
2421           SB        PORTLAND           A
2421           HQ        SAN JOSE           A
2421           HM        KENOSHA            A
2422           BI        ERIE               I
2422           MA        DALLAS             A
2423           BI        CORONA             A

of course there are more fields, but I just wanted to give you a picture of what the table looks like.
If you need anything else, please just let me know.

Thanks again!!!!

Chris