How can I pass both the UserId and Password to the FM database in IWP? When my client logs in I would like the UserId & Password to be passed to the database so a search can be made on just that client's records and only that client's records will display. I can not just use the UserId ( Get(AccountName) ) because I have a few clients with the same last name and there is no Get(Password) function. Can the Password field be retrieved by another function?

Thanks in advance - Sam

How can I pass both the UserId and Password to the FM database in IWP? When my client logs in I would like the UserId & Password to be passed to the database so a search can be made on just that client's records and only that client's records will display. I can not just use the UserId ( Get(AccountName) ) because I have a few clients with the same last name and there is no Get(Password) function. Can the Password field be retrieved by another function?

Thanks in advance - Sam

How can I pass both the UserId and Password to the FM database in IWP? When my client logs in I would like the UserId & Password to be passed to the database so a search can be made on just that client's records and only that client's records will display. I can not just use the UserId ( Get(AccountName) ) because I have a few clients with the same last name and there is no Get(Password) function. Can the Password field be retrieved by another function?

Thanks in advance - Sam

No, the password cannot be retrieved. Think of the security hole this would create if it could...

Have you tried setting the record level access (RLA) privileges to limit the browse rights?

No, the password cannot be retrieved. Think of the security hole this would create if it could...

Have you tried setting the record level access (RLA) privileges to limit the browse rights?

No, the password cannot be retrieved. Think of the security hole this would create if it could...

Have you tried setting the record level access (RLA) privileges to limit the browse rights?

I'm missing something here... For the login have them login with both first name and last name and a unique password . Do any of your clients have both FN and L names the same..?

Stu

I'm missing something here... For the login have them login with both first name and last name and a unique password . Do any of your clients have both FN and L names the same..?

Stu

I'm missing something here... For the login have them login with both first name and last name and a unique password . Do any of your clients have both FN and L names the same..?

Stu

Just because your users have the same last name doesn't mean that they can have the same account name.... account names have to be unique, so you can always use get(accountname) to control access to records.

Just because your users have the same last name doesn't mean that they can have the same account name.... account names have to be unique, so you can always use get(accountname) to control access to records.

Just because your users have the same last name doesn't mean that they can have the same account name.... account names have to be unique, so you can always use get(accountname) to control access to records.

Thanks for the suggestions. What I am thinking of doing is to tell my clients to combine their login (last name, password) in the first login field (username) and then have them place their password again in the password field. This should solve the Get(accountname) problem with two clients with the same last name.

Thanks to the FmForums community - Sam

Thanks for the suggestions. What I am thinking of doing is to tell my clients to combine their login (last name, password) in the first login field (username) and then have them place their password again in the password field. This should solve the Get(accountname) problem with two clients with the same last name.

Thanks to the FmForums community - Sam

Thanks for the suggestions. What I am thinking of doing is to tell my clients to combine their login (last name, password) in the first login field (username) and then have them place their password again in the password field. This should solve the Get(accountname) problem with two clients with the same last name.

Thanks to the FmForums community - Sam