Using Excel Bible 2016. Trying normalization. Beginner on Ch. 8 Queries
Account Manager A has contact 1 for Pizza and Hot Dogs at company Z owned by Walmart.Account Manager A has contact 2 for Pizza at company X owned by Walmart.Account Manager B has contact 3 for Hot Dogs at company Q owned by Winn Dixie.Customer Contact is parent. Contact and Company are children.
- ContactID = table for info describing contact person for commodity
- CommodityID = Split? The commodity won’t change. If contact