I have a list of constituent ID's of schools that I want to associate to their school district. They all need to be se the same relationship (school/ school district) and I have all of the constiuent ID's.
Is there any way to create these relationships in bulk? Or do I have to add the relationship to each school manually?
Hi Ragan,
Is the school disctrict also a constituent (It's an attribute for us)? If so (and you have SSMS access) I think that it'd be pretty simple to insert into the T_ASSOCIATION table. I'm about to do a similar thing for the T_AFFILIATION table with media orgs and reporters.
Cheers,
Heath
You can insert into T_ASSOCIATION but there are serveral considerations. You need to make sure you keep association numbers in line with the T_NEXT_ID table and make sure that table is updated after an ID is added. You have to make sure you properly set up reciprocal assocation numbers. You have to make sure the association types match up properly.
I'm actually doing this currently and am running into some issues. It looks like it can be done but it's not as simple as inserting a line directly into the table. More logic is required.