We have over a thousand Associations and Affiliations that need to be updated. In cleaning up data we found that about half of the above have the "Default Association Type" as the association type. The reciprocal association/affiliation have the correct description. The table has been updated with correct reciprocal types and the default association type has been inactivated. Now come the request... Does anyone have SQL or a procedure that they could share to update the affiliations/Associations so that they update with the correct description?Thanks
Margaret