I've used the TMS Bulk Importer to migrate legacy records from our Catalog and from our Digital Gallery into TMS. This has worked pretty well, as I'm dealing with several 10s of thousands of records. However, you can only put one Constituent in that way. I've been able to write SQL to map other data which isn't accommodated by the Bulk Importer, but the relationships between Objects & Constituents tables is impossibly complex to me. If I upload a table AddConstit with ConstituentID, ObjectID, and RoleID, how do I actually attach the name to the object? Any SQL masters out there?