i have a problem that i hope you can have a solution for it, i have two ASP scripts that requires the users to register, and i incuded both the tables in one database, everyone contains ( username, password, first name...etc ) and i want to configure them so that when the user register in one table, he automatically gets regitered in the second table! is that possible ? notice that for example the ALIKE columns doesnt have the same name in the two tables, for example the username table in one table is ( username1 ) and in the other table it is ( username2 )! is it possible to relate them so that when username1 is updated, username2 also becomes automatically updated and vice versa ??? please try to help me out because it is not likely to make users register MANY times in the same site! i want the registration to be UNIQUE so that when the user gets registered in any of the services he automatically gets registered in all the other services with the same info like the username and password....
thanks for your valuable time and i hope you can have a solution for me...

-----------------
AkMaLiTo-C RuLeZ
-----------------

You can update more tables using Server Behaviors > Command/Stored Procedure.
You should also create relationships between those tables directly in DB.

Viktor Farcic

TalkZone Manager

i didnt find the command/stored procedure! where is it in the UD4 ?? and i also tried the relationships in the DB but i didnt succeed in doing that !! please help me

-----------------
AkMaLiTo-C RuLeZ
-----------------

You can Access Command(Stored Procedure) from Server Behaviors (click on + sign).
To create realtionship you need to have primary key in one table and corresponding field in other. What DB are you using?

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
i didnt find the command/stored procedure! where is it in the UD4 ?? and i also tried the relationships in the DB but i didnt succeed in doing that !! please help me

-----------------
AkMaLiTo-C RuLeZ
-----------------
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Viktor Farcic

TalkZone Manager

Hi, thx for the reply, i found the comman/stored prosedure, but i dont have a clue about how can this option can make me update two tables in the same time???? please inform me cuz i am not good in hand coding

-----------------
AkMaLiTo-C RuLeZ
-----------------

Send me more data and I'll try to make you some working example.

Viktor Farcic

TalkZone Manager

Him i sent you an email on the address containing the data you asked for because it was messy when i tried to paste it here... you will find the mail from with the subject [ i am AkMaLiTo-C from the UDzone members ] .. sorry if i asked too much but i really didnt find any1 else to help me out in that <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle> thanks for your time

-----------------
AkMaLiTo-C RuLeZ
-----------------