CodeCharge Studio
search Register Login  

Visual PHP Web Development

Visually Create Internationalized Web Applications, Web Reports, Calendars, and more.

YesSoftware Forums -> CodeCharge -> General/Other

 Two Table Issue

Print topic Send  topic

Author Message

Posts: 12
Posted: 02/21/2004, 8:15 AM

I have searched this forum and can't seem to find an example that closely resembles my issue. I'm using CC, ASP, & MS SQL.
I'll simplify:

I have two tables, Table1 and Table 2.

Table1 has 3 fields:
FName, LName, PNumber

Table2 has 8 fields:
OrderID (Autoincrement), FName, LName, PNumber, PlusUpg, DeluxeUpg, FamDeluxeUpg, Total

I want to create a record that displays the 3 field from Table1 and only the (OrderID (Autoincrement),PlusUpg, DeluxeUpg, FamDeluxeUpg, Total) fields from Table 2 but upon 'Submit' updates only Table2. I know how to use session variables to get the info from Table1 to display, I'm just hitting a wall on how to display fields from Table2 and update only Table2. I'm a newbie so please be gentle in your explanation if this is possible. Hopefully, I've explained this well. Thanks in advance for your help.

View profile  Send private message

Posts: 509
Posted: 03/04/2004, 7:04 AM

I think the following should work.
On the record form use table 2.
Display the field FName 3 times.
Two of them set to label.
Then you can use Join on their field properties. There you connect them to table 1 and display these two fields from table 1. Maybe you have to check that the field names for FName are different for each of the three uses of it.

Best regards,
View profile  Send private message

Add new topic Subscribe to topic   

These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit

Internet Database

Visually create Web enabled database applications in minutes.

Home   |    Search   |    Members   |    Register   |    Login

Powered by UltraApps Forum created with CodeCharge Studio
Copyright 2003-2004 by  and YesSoftware, Inc.