3 tables. item, brand, commercial
item
Item
Thanks, Michael. That worked perfectly. For some reason I had all the relationships exactly backwards.