This topic is locked

AutoFill Fields From Another Table Based on A Lookup

2/27/2009 11:29:32 AM
ASPRunnerPro General questions
B
bpawlowski author

Hello
Here's the situation. I've been tryig to do this for a while, but have had no luck. I have 2 tables "Artist" and "Agents". On the "Artists" page, I want to have the person select the "Agent" (which I can do using the Lookup...not the problem), and then have some of the "Agent" information populate fields in the "Artists" page. I want the values to automatically be written to the "Artisit" table.
I've created the corresponding fields in the "Artists" table, but I'm not sure how to make it automatically write to the "Agent" data into these fields. I'm trying to move over:
Phone Number and Location into the "Artists" tabl from the "Agents table.
Any help would be greatly appreciated.

Sergey Kornilov admin 2/27/2009

I recommend you to setup dependent dropdowns on Add/Edit pages so once you selected an Agent other field are populated as well.
Dependent dropdown boxes may appear as regular textboxes if you choose "Edit box with AJAX popup" option.

A
agruspe 5/5/2009

Below is the demo link for the solution provided by Sergey:
http://demo.asprunner.net/agruspe_maribb...Table1_list.asp
Try adding a new record either using the 'Add New' or 'Inline Add'. As you change the subcategory, it autofills the 2 other fields.

K
KoolMomma 8/11/2009

The demo account url provided above is no longer available. Can someone post instructions on how to setup the dependent dropdowns? Thanks!! v/r Lisa

J
Jane 8/11/2009

Hi,
please check "How to setup dependent dropdown boxes on Edit/Add pages" tutorial here:

http://www.xlinesoft.com/asprunnerpro/tutorial.htm