Thanks David. I can see the campaign table and the link to the program table which holds the folder information. What I can't see is a how the folder can be changed for the campaign as the program file foreign key isn't visible or accessible. If I look at the documentation tab of the schema definition for nms:campaign I can see foreign key iprogramid.
