Set Criteria which select entries based on another view

Set Criteria which select entries based on another view

Hello

A need to create a view which display only data which has the same match field that exists in different view.

Form A:

Vendor_number
User_email_address (where I enter the email address for people I'll share the app with). Examples:

10, smith@domain.com
20, charles@domain.com
10, book@domain.com

(note that vendor 10 appears twice since I share the app with two different users)

Form B:

Vendor_number
Product
Price

I would like to create a VIEW in form B which select all entries which have vendor '10' (or the email address of the user logged on, contained in Form A)?

I know that I can create a view in Form A which which shows all entries that are associated with an email address in the form (I will call this view 'Select'). This view will show Vendor_number and email_address.
in the criteria for the view: User_email_address == zoho.loginuserid


What I don't know is to show all entries from form B which have the same vendor_number as the one in the view 'Select'.

Note that there will be more than one email address associated with the same vendor_number.

Thanks.

E Capitani