I've been asked to create a custom field (Check #) for contributions that can be pulled into an acknowledgement letter. I've created the field and it works fine in the ack letter as long as the check # is manually entered into the field when entering the contribution. My question is this, is there a way to set up the t_keyword to pull the check # from the t_payment table and automatically populate the custom field?
Sounds like a neat place to use a v11 "custom hook". Until then, though, AFAIK you'll need a stored procedure + a scheduled SQL Agent Job.