Jump to content

Web login user name

This topic is 6808 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies


I have a database online and I'm kind of stuck on a user name issue.I have created a custom login layout that works fine. When the user logs in the user name is a global field. What I'm trying to do is match the current user name to a record in a different table.


Table 1 is an order form.

Table 2 is client information.

When user "Bobby10125" logs in, I want him to be recognised by his client information in table 2.

In table 2 the record would have the client code (10125) and information for that account.

When "Bobby10125" logs in to table 1, I want it to match the global user name with the appropriate account, and display order information for that account.

So "Bobby10125" get(currentuser)

If get(currentuser) = clientinfo::usernames

set field(usercompany)=clientinfo::companyname

If "Bobby10125" logs on it should show that he works for Smith & co. based on the information in the Client Info table?

I thought that would work to pull information based on the username, but I have not had luck. I'm new to this and I'm obviously missing something here

I hope I'm making sense.

I'd appreciate any help anyone has to offer.

Thank you

Link to comment
Share on other sites

This topic is 6808 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.