Auto-populate a fields

Hello,
I have 2 Form as follows:

Form 1 with title (Users) it contains the following fields:

1. First Name (Text)
2. Last Name (Text)
3. Company (Text)

Form 2 with title (Cars) it contains the following fields:

1. Select User (SelectSQL) auto-populate a list with items from a Users table.
2. First Name (Select)
3. Last Name (Select)
4. Company (Select)
5. Car Name (Text)
6. Car Model (Text)

In the first form (Users) there is no problem.
What is required is that when I select User's name from the list of (Select User), the fields (First name, Last name, Company) are automatically filled in with data from Form (Users).

I've read most of the threads on this forum and the documentation too but I didn't understand the scenario because I'm not an expert, and I wish you guys would provide any examples.

Hello ykinanah,

there will be a complete example to your requirement shortly.

We see this as a deficiency in the Visforms documentation and will update it to reflect your point.
I have created a development issue for the documentation wish list:
Issue [VF-856] Forum: Docu: SQL Fields: Add example with 2 forms reusing the data

If we have expanded the documentation, you will be explicitly informed about it here in the topic.
Thank you for your contribution!

Kind regards, Ingmar

Hello ykinanah,

the issue from above has been implemented.
Issue [VF-856] Forum: Docu: SQL Fields: Add example with 2 forms reusing the data

The following section has been added to the documentation.

Users and Vehicles:
docs.joomla-4.visforms.vi-solutions.de/e...orms_users-and-cars/

Kind regards, Ingmar