|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
 AT&T devCentral & BlackBerry(r) Webcast Series: BlackBerry and GPS -Build Location Awareness into your BlackBerry Applications, July 10th-1:00PM EST. Register Today!
|
|
#1
May 10th, 2004, 12:17 PM
|
|||
|
|||
|
changing one field updates 3 other fields, use a join?
i currently have a table like this..
Code:
user_id username app_id app2_id app3_id app4_id 1 john 3 4 5 6 2 mike 4 5 6 6 3 manager 4 5 6 6 4 vicepres 5 6 6 6 5 ceo 6 6 6 6 6 board 6 6 6 6 the basic pattern is... a user has approvers, and those approvers have approvers as well... i have 4 columns of approvers.. and if my first approver is the manager, then my second approver will be the managers approver and my third approver will be the managers approver's approver and so on.. on my actual page, i have select fields for the app, app2, app3, app4 and i need it so that when i change the very first app, it'll automatically update app2, app3, and app4 any ideas how i would do this? im pretty new to sql but im thinking i would use some type of join? thanks
|
|
#2
May 11th, 2004, 02:19 AM
|
|||
|
|||
|
From your example, looks like the App_id to App1_id, App2_id, App3_id, and App4_id assignment is always the same?
Meaning that I woudn't see something like this?... Code:
user_id username app_id app2_id app3_id app4_id 1 john 3 4 5 6 2 mike 4 5 6 6 3 manager 4 5 6 6 4 test_1 4 7 3 8 5 vicepres 5 6 6 6 6 ceo 6 6 6 6 7 board 6 6 6 6 8 test_2 6 9 11 12 ...note that the red fields have diff appX_id assignment than previous records that have the same app_id. Last edited by Username=NULL : May 11th, 2004 at 02:21 AM.
|
|
| Viewing: Dev Shed Forums > Databases > MS SQL Development > changing one field updates 3 other fields, use a join? |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
