Linking Tables together to make a set

[anolian]

Hey all i am trying to link too tables together. here is what i have, i have a customer info table where there are fields for there name address and so on. I have it so when ever so one signs up the infomation the provide is then shown in that table. I also have a log in function. and i have a username table that has every ones username and passwords. I want the username table to grab the username and password from the customer info from the customer info table. so when ever some one signs up and adds there username and appssword i want it to show up in the username table. can some on please help me on this matter.

Thanks

[Edward Larrabee]

If you are creating a set, and if the username is in the address table, then you do not have to place the username in a second table. It would be easier to help you if you explained what fields you want to store in each table of the set.

Have you defined a unique key field that will link the 2 tables?

[anolian]

well for the first table whic would be called customer info. i want there (first name,last name,address,postal/zip code,country,email address, username, password) and for the 2nd table i want it to have username,password, and level of security) i made a web componet ofor the customer table and but it on my sign up page. and i made a web componet for for the sign up box on the mian page.

[Edward Larrabee]

Why do you want 2 tables?

[anolian]

i dont i would like one but i thought i had to make a seperate table for jut usernames. since if i make a login with the customer info table wont i get all that other info like there name and address. I just want the login componet to say username and password. and i want to set the security level to each contact.

Could u tell me how to do that with the customer table. Please

[Edward Larrabee]

When you create a grid component, you only place the fields that you want the user to see. It doesn't matter what other fields are in the table. When you create a dialog component, you write an Xbasic script that reads and writes only the fields that you select. Again, it doesn't matter what other fields are in the table.

[anolian]

ok i made it new table and i called it members. here is the xbasic code i used

if members = "" .or. password = "" then
currentform.has_error = .t.
currentform.error_message = "User name or password cannot be blank."
else
dim correct_password as c
DIM level AS N

correct_password = lookup("[PathAlias.ADB_Path]\members","members=" + quote(members),"password")
if correct_password = password then
level = lookup("[PathAlias.ADB_Path]\members","members=" + quote(members),"level")
session.__protected__SecurityLevel = level
session.WASDemo.UserName = members
ELSE
currentform.has_error = .t.
currentform.error_message = "Invalid user name or password."
end if
end if.

And i keep on gettign an error in: event.form Level validate code:
variable "members" not found.

not sure why i used the exact code i had before and it worked fine. so im thinking. its something to do with with where the files are?

[Edward Larrabee]

Is "members" the name (not the label) of a control on the dialog component?

[anolian]

i dont follow the name of the table is members.

[anolian]

i think i figured it out but a new problem as arose. when i sign up and add all the info i need like name address and so fourth. and then try to log in with the username and pass i just used it works fine. but the problem is when i try to sign up again there are two sign up boxes one above with the sign up information i just input and there is a new sign up box that is blank. how do i get it so i dont see the sign up box that has all the info i just input in earlier.

[Edward Larrabee]

This code is testing whether the members or the password controls on the dialog component have null values.

if members = "" .or. password = "" then

[anolian]

??? sorry i dont follow what do i put in there. do make those tables not viewable

[Edward Larrabee]

What are the names of the controls on the dialog component?

[anolian]

do mean mean what is checked on and off in the control tab?

[Edward Larrabee]

Let's start over. Are you making a grid or a dialog component?