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