User Profile
Nate_Alcantara
Copper Contributor
Joined Feb 09, 2021
User Widgets
Recent Discussions
Re: Promotion Database
Hi George_Hepworth. Here are the summarized relationships. 1 Trade Activity = 1 Division (Essentially, under a division, there are several trade activities) 1 Trade Activity = Many Channels 1 Trade Activity = Many Areas 1 Trade Activity = Many Volume Allocations What are your suggestions on this?Re: Promotion Database
George_Hepworth Hi there. I updated my database and relationships based on your suggestions (See attached photos) Allocation means the amount of products (in cases) to be given to our customers. Which means that 1 Promotion = Many Customer allocations. My problem is I need to figure out a way how I can encode the allocation part in the Trade Activity Entry Form I designed. I also need help in fields that need to have multiple selections and I don't know how to do that. The two fields are Target Area and Channel Type. Thanks so much for all your help!!Re: Promotion Database
Daniel_Pineault I work for a canned goods manufacturing company and one of its marketing efforts is creating promotions/trade activities. Promotion to allocation means that one promotion has multiple accounts/customers to be allocated to. In our system, our customers have address codes so I have a table for this plus a table for the promotion details. My main problem is in terms of encoding for the end-user, how can I design the form efficiently enough that multiple accounts can be encoded per promotion form.
