Trying to update with value from another table (Full Version)

All Forums >> [Web Development] >> ASP and Database



Message

clirvin -> Trying to update with value from another table (4/22/2008 16:32:34)

Any help I could get would be awesome!

I have a FrontPage 2003 website with Access 2003 Database. Here's what I'm trying to accomplish....

The table Leads1 has a field for ISP. This field is to be set by an online form by a manager.

The table ISP_Login is where the values need to come from.

I want to set up an update form to choose the ISP_Name from ISP_Login and update the Leads1 table ISP field.

Any suggestions?



crosscreek -> RE: Trying to update with value from another table (4/22/2008 18:04:33)

If I'm understanding what you are asking correctly...

lead1 table
Lead1ID <--this is your primary key
ISP


ISP_login table
isploginid <---this is your primary key
isp_name
leads1id <----this is where you use to make your JOIN.

Go to your query design & choose your isp table & lead table...

Now click,hold, & drag the leads1ID (from isptable) over to the leads1id (leads1 table)

Now you will see a line...double click the line & choose option 2.

You are making a left join from isp table to leads1 table.

This is your query to select the fields you want to update.

from here you need to make an update query using the same JOIN type.

Hope this helps




clirvin -> RE: Trying to update with value from another table (4/23/2008 9:20:59)

Thanks for your response, but I don't think I explained myself clear enough. I am using FrontPage 2003 and Access 2007 (saved as 2002-2003 so that it is compatible).

Leads1 is a table.
Leads1_ID is the Primary Key
ISP is a field within this table, formatted as text
This table holds sales leads, some of which have not been assigned to an ISP.

ISP_Login is the other table
ISP_ID is the Primary Key
ISP_Name is a field within this table, formatted as text
This table holds the names & contact information for each ISP.

I need to be able to assign each record in the Leads1 table to an ISP from the ISP_Login table through a website.

I am using the Database Results Wizard to show the records from the Leads1 table. I want the Sales Manager to be able to choose an ISP from a drop down menu and have that ISP (from the ISP_Login table) input or updated to the ISP field in the Leads1 table.

Does that better describe it?

Thanks!



Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.1088867