Linking records across tables automatically?

I have a client who is having folks apply to submit products for an online store.

The applications are entered automatically from a Jotform integration into the “Sellers” table.

The Sellers then begin submitting products through another Jotform. I do not want them having access to the other sellers data, or picking something incorrectly, so I have them enter their email address again and that is entered into the “Products” table.

Is there any way to automate linking the Product to the Seller using their email address? When I try to use a lookup field its only showing me a separate “linked” fields as an option, and I can’t look up the email field.

Thank you in advance. Open to reworking this as well of course if someone has more elegant ideas.

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.