Join Tables Without Using Pk

Hi all,

I’m using the Gallery Manager extension which has a Gallery model connected with a one-to-many relation to the GalleryPhotos model.

I have a products model that I want to join to a Gallery model with a one-to-one relation.

How would I define such a relation given that I don’t want to modify the Gallery table (to add a FK).

One option is adding a gallery_id field to my Products table that would point to Gallery->id but how would I define the relationships in my Products model file?

Thanks in advance.