I am adding vendors and products into the CRM and I would like to know if anyone has tips or tricks on how to deal with multiple vendors offering the same products. I decided to create a subform in the products module, which includes a lookup field for the vendor, along with other product-related fields such as cost. And for the main product fields I am entering the cost and details from the primary vendor.

I'm hesitant to create a product for each vendor. I am hoping to get more insight on how others have managed this issue. Thanks!