I have a SQL view that links my contact table to my address table. In the view there is a field signifying "address_type". It could be mailing, location, business, home etc.
When I run the query I get three records for this contact because they have mailing, location and business addresses. Is there a way in Crystal to select the record I want based on address_type when this particular contact may or may not have a business or location address but rather a single mailing address.
To further explain, if they have a mailing address I want that record. If no mailing address I want the business address record. If no business address I will use the home address record.