Link two collections automatically

Hello,

I’m stuck in building my application to link the databases together. I would like to automatically link the databases together by means of a property that shares the same records. However, I can’t do it. Indeed, I have to link the databases together by intervening line by line. Could you tell me how to link the data automatically or in a group way (and not line by line)?

I thank you in advance for the help you can give me.

Hey @Caroline422, this is how relationships work, when you want two collections to be linked, you need to add a “Relationship” property to one of the collections in the database. This connects the two collections together.

Then on the screen where a record gets created, you add an action or automatic field (if you’re using a form) to link collections together. This links the two records together at the moment the form is submitted, automatically.

After doing this setup, every new record created through that form will be linked automatically.

Two articles that might help:

How to set up relationships: From Structure to Connections: Setting Up Effective Relationships in Adalo

Real-world example: How to Build a Marketplace App in Adalo: The Complete Database Structure

If you share which two collections you are trying to link and what triggers the connection, I can give you the exact steps.

Ali Bazzi — Adalo Expert | adalo.com/experts/ali-bazzi

Good evening Ali, thank you very much for the procedure, I’ll try and come back to the forum to tell you if I succeeded.
See you soon

You’re very welcome @Caroline422! Please take your time, and let me know how it goes.

Ali Bazzi — Adalo Expert | adalo.com/experts/ali-bazzi