Dependent Lookup Autofill

Arnel,
you can have multiple dependent dropdowns linked to the same master control. Is that what you looking for?

Hi Sergey,
Actually, I am using only one dependent lookup that should/will fill-in 4 fields. MAKE is a drop-down lookup from Lookup1 while MODEL is the dependent drop-down lookup from Lookup2.
Main Table

Client

Make -> dropdown based on table Lookup1

Model -> dependent dropdown based on table Lookup2

Option1 \

Option2 | These fields should be auto-filled from values on table

Option3 | Lookup2 depending on Model

Option4 /
In my scenario, the MODEL field is the dependent lookup. When a user selects a model, it should automatically fill the OPTION fields of the main table with the value from OPTION fields of Lookup2 table. Table Lookup2 is also the price table.
My client is a custom-builder of trailers (various models) <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=38205&image=1&table=forumreplies' class='bbc_emoticon' alt=':ph34r:' /> and requires a variety of customer options such as brake, lights, etc. Different pricing for every model depending on the options. I am using the CARS template as inspiration to suit the requirements.
Thanks,

Arnel
ps.

I forgot to include the PRICE field which needs to be update and its value is also from Lookup2 table.

Resolved the problem already.
Below is the demo link of a sample how it works.
Demo account to show how dependent-dropdown with autofill to other fields.

I received a PM from Newbe how this was achieved. For those who would want to know how this is achieved, below is the screen shot of the properties of Field1 of the demo

The link field Other1 is the value field that you want to pass into the main table but this is dependent on Subs category control.
You have to select Edit box with AJAX popup to "fake" the user that this is a field and not a drop-down.
Take note that the contents of Other1 field "grabbed" can be edited by the user. Should you wish that the user cannot edit this, search within this forum how to disable the field edits (Jane and I have topics already with this).
Should you find this helpful, a simple thanks added below this topic (and thanks to the developer of ASP Runner) is highly appreciated.
Jane/Sergey,

Can we make a copy of this thread to the TIPS AND TRICK section.
Thanks,

Arnel

Arnel,
thanks for sharing!
I grab all required info from this thread and post it to Tips and tricks. In fact you can do this too and get all the kudos.