As of April 17, 2018, this site is now in read-only mode. To start new Blackbaud Developer’s discussions, you will find Developer Discussions in the Blackbaud CRM Community.
To post or respond to Blackbaud Community discussions, you will have to login using a www.blackbaud.com login. Learn how to login here. If you have questions or need assistance, please email email@example.com.
I built a table which is an extension of the DESIGNATIONLEVELRECIPIENT table to house some additional data about scholarships.
After building and deploying my adddata form extension spec... when I try to create a new record via the form I receive a FK violation message. I assume this is because the record has not be created yet in the primary table (DESIGNATIONLEVELRECIPIENT). How do I extend this form and make sure the base record is committed first - before populating the additional fields in my table extension?
I thought about grabbing the standard SP which creates the record in the base table and modifying it to include all of the base (standard) data fields as well as my new extended fields... is that best practice?
Figured it out... I wasn't using CONTEXTID in my insert.
Replaced ID with CONTEXTID and all is well
In your table extension do you have this in the meta data?
Then make sure that your add form has a context ID that has the record type of: DESIGNATIONLEVELRECIPIENT
The for the ID of the extension record make that the context ID.