Best way to associate products with a custom module

Best way to associate products with a custom module

I'm getting us up and running for the first time with Zoho. It'll be used to help manage a photography business.

I've setup Deals (renamed to Opportunities) and have a couple different layouts -- one for a Photo License and one for a Photography Channel (a deal with a distributor such as a Gallery).

I also created a custom module called Photo License, with extensive custom fields that will help me keep track of the huge number of details applicable to each license a customer buys from me.

I configured the Products module with a set of fields relevant to each individual photo I sell -- serial number, URL to the image in my SmugMug gallery, and so forth. I intended to have one Product record for each image, and another product record for each kind of mounting, framing, matting, etc. option is available through our print house.

For any given Opportunity, I want to be able to associate 1 or more Photo Licenses. On the bottom of the Opportunity record layout/view screen, I want to see a related list that shows all the Photo Licenses associated with that Opportunity.

For each Photo License record, I need to be able to associate 1 or more photos.  On the bottom of the Photo License record layout/view screen, I want to see a related list that shows all the Products associated with that Photo License.


I'm at a bit of a loss how to set this all up. I figured Products would work fine for this purpose since it's already an existing module, but I can find no way to associate products and deals/opportunities, or to photo licenses. And I'm having a hard time figuring out how to get the related lists configured.

Can anyone help here? I'm on Enterprise Edition.