Not able to link 2 databases

[vzutshi22]

HI
I am new to Bubble. Trying to learn. I have 2 databases as follows:-

On the app I have a button which is Add to Cart. So once a user clicks the button I want data from Product_desc and Product_image fields in Product database to be added to Order_Product_Desc and Order_Product_image fields in Order_Detail database. I have also created the following workflow on the Add to Cart button:-

Somehow this workflow(Make changes to things) is not working. Kindly advise great bubblers.

Thanks
Vijay Zutshi

[nfisher]

Just to clarify, these are separate data types/tables with in the same app? It would usually make sense to store the Product ID to the transaction, that way it can be referenced from the data base.

[vzutshi22]

Thanks for a quick reply. Yes these are 2 separate tables in the app.

Thanks
Vijay Zutshi

[vzutshi22]

@nfisher

store the Product ID to the transaction

So what do you mean by store the Product ID to the transaction. That means I should create a unique identifier of the selected item in the Product database. But the question still remains the same how do I read that info from Product database and add that to the order database.

Thanks
Vijay Zutshi

[adamhholmes]

Just use a single field to store the Product.