Linking data from two forms, each located in different application

Linking data from two forms, each located in different application

Dear Creator community, Hello :)

My situation is as follow:

I have one application which contains a form with customer data:
Application A, Form A:
Row: Customer ID, First Name, Last Name

Application B, Form B
Row: Customer ID (look up field to Application A, Form A ,Customer ID) First Name, Last Name

Application A is my master database, while application B is a secondary database created per user

The desired process is as follows:

I register a new user in application A database
then, when i create application B i look up his customer ID, and when this ID is chosen i want to add a work flow that will take this Customer ID, go to application A form A and return the first name and the last name of the Customer with the Customer ID searched.

In other word, every table has a unique key which can be used to associate it with data in other tables and applications, and i want to be able to fetch data from one application to another using a common key.

So far i found only the fetch data deluge task which can only fetch data within forms of the same application

Any one has a better idea?

Thank you
Tal