Populating a dropdown list in another table using the record names

[greenbeangt]

I have a database where the first table is the registrations, then I have four more tables with their own forms. I want people that registered in the first one, to find their name in the other forms instead of filling it out again. So what I need is for the the name of the records from the first table (registration), to automatically populate a dropdown menu in the other four forms. Do you know an automation to do that?

[Sistema_Aotearo · Accepted solution]

Hiya! Use the "Link to another Record" field. This will allow users to find and select records they already have made in another table.

Let me know if this helps

[godofprogrammer]

Yes, you can set up this kind of automation! You can use database triggers or scripting to automatically pull names from the first table and populate the dropdowns in the other forms. For example, you might use SQL queries to fetch names and update dropdown menus in your forms dynamically. If you're using a platform like Airtable or Google Sheets, they also offer built-in tools or add-ons to help with this.

[greenbeangt]

Thank you! It worked by Linking it to another record!