Link between a record producer and catalog item

[Jaya9]

Hi , 

 I have a record producer for creating a vendor and i have a catalog item for gathering information of that vendor .

There is a scenario and i want help as how can i achieve them : 

As user x submit a request for vendor y in a custom table vendor onboard through record producer (eg:VEN00012) and as soon as that is submitted a mail gets triggered to vendor y to submit details of them through catalog item .  Vendor y enter all details and submits . It creates a request and ritm (RITM000112).

First issue is i want to show the associated request/ritm in vendor onboard record . How can i achieve that ins simple words want to link vendor onboard request record and vendor details submitted through catalog item .just like we associate an incident to a request .

Second is i want to send a mail to user x for approval of the details submitted by vendor in RITM000112.

Please let me know how can i achieve these both or let me know if any further details are required .

Thanks in advance 

Regards,

Jaya

[Dr Atul G- LNG]

Hi @Jaya9 

when as user x I add details in record producer  for onboarding a vendor it gets submitted in table u_vendor_onboard . And catalog item details are entered by vendor y which creates a record in sc_request table .

Atul: As you said, the catalog item will be created by Vendor Y , so in this case we need to build some common fields in vendor table and catalog item to make a linking, even as suggested by @OlaN 

I want to link these both that means record in u_vendor_onboard table should let me know which request is associated to it .. if I can achieve this through flow designer can u provide me further details how