CodeCharge Studio
search Register Login  

Web Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> CodeCharge -> General/Other

 Two Table Issue

Print topic Send  topic

Author Message
andrico

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.

Rico
_________________
Rico
View profile  Send private message
mrachow


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.

Michael
_________________
Best regards,
Michael
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 http://support.yessoftware.com.

PHP Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


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