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 |
|
|
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 |
|
|
|