How to link 2 database together?

HCL Domino Domino Forum
1

Dear all expert,

I have develop 2 database, database A and database B with domino designer. These 2 process workflow is not using the Lotus workflow architect.

Database A contain field as below:

username, department, head of department

Database B contain field as below:

Purchase requisition, department, quantity, price.

When user create purchase requisition in database B, They just need to fill in Purchase requisition, department, quantity, price. And the Purchase requisition will route to head of department by searching database A for approval according to the department in database B.

Please advice.

2

Subject: @DbLookup + why not merge ?

While the intended process is not super clear, it seems as a classic case for @DbLookup.

Besides, do you really need two databases ? Seems to me you’d be better off merging them.

3

Subject: how to merge?

Hi, Thank You for your response. But database A will be used in the future for other database. It might be use for database C, D and so on.

So how can I develop a database which can be use commonly by other database?

Thank you.