sql = "INSERT INTO tbl1 (col1, col2, col3) VALUES (val1, val2, val3)"

adoCon.Execute sql

 

to make it so that only userA can see userA's specific records, set a relationship between the key field of the user information table (the one where you keep passwords etc) and an equivalent field in the table where the new records will be kept.

 

For example, if userA has an ID number of 0001, then create a field in the table you want to add new things to called userID or something like that, and then use the sql insert to add the new record. Like this:

 

userIDvar = {the ID of the user}

sql = "INSERT INTO tbl2 (column1, column2, column3, userID) VALUES (value1, value2, value3, userIDvar)"

adoCon.Execute sql

 

hope that makes sense.

Doses it means that i shall have 2 tbls in my database. if i create the relationship shall i point it to tbl1 primary key and tbl2 primary key.

 

This is how i did mine:

 

userID = request.querystring("ID")

 

strVALS1 = request.form("txtVals1")

strVALS2 = request.form("txtVals2")

strVALS3 = request.form("txtVals3")

 

sql = "INSERT INTO ([col1,col2, col3, U_ID]) VALUES ('" & strVALS1 & "', '" & strVALS2 & "', '" & strVALS3 & "', userID)"

adCon.execute sql

 

But is still not working

 

In my admin area where i select the member i wish to add new records to it profile using it assign ID. That is the ID when the member get registered.

 

Just tell me how the 2 tbls is going to look like.

Please still help me out.

 

One would have username, password and other relevant details (like contact details - phone number, address, etc) as well as a UserID field which would be and autonumber

 

The other table would have whatever fields you need in it for the new records, as well as a UserID field which was simply text.

 

then you would set a one-to-many relationship from UserID in Table 1 to UserID in Table 2. Then use the sql insert into table 2, inserting userID as appropriate for the user.

It works vey well now but i'm still having alittle problem.

 

How can i use SELECT METHOD to display the record in tbl2?

I try to do that but am having an error when i want to display it.

 

something like this:-

Error: Data type mismatch in criteria expression.

 

So, this is how i did mine.

 

userID = request.querystring("ID") 

 

strSQL = "SELECT [col1], [col2], [col3], [uid] FROM tbl2 WHERE uid=" & userID

 

But is not working. Plz, help me out.

 

I want to displayed the records in tbl2.

i suggest u read the last post before replying. Just read the previous post okay.

cox i know what am asking of.

 

I will apply this method u show me now.

i get to you when is okay.