Hi all,
I'm trying to brainstorm a custom tab that looks at T_Promotion. What I would like is for the Constituent custom tab to show all the campaigns/appeals/sources for a particular campaign category and/or appeal type (so from a view). But then allow a user to update the custom table with solicitor and a money value. And also choose a Response which could use a trigger to update the response in T_Promotion.
Does anyone have an example of a custom tab that shows a view from another standard table but allows updates to the joined custom table? Can I have a custom tab look at a view and still update a custom table? Or how to put those customer_nos, campaign_nos, appeal_nos and source_nos in the custom table without putting a trigger on T_Promotions?