difference password for each user to open the same form

[peterth]

Hi all Alpha expert,

I use form and enable the password for any one to use form.
How can I set up the difference password for each user to use the same form. I see only one password I can use for that form.

Log in in difference user and keep it in variable and use it to check if what user and compare with its password for each user to access that form?

Please advise and commend

Thanks
Peter

[Stan Mathews]

Re: difference password for each user to open the same form

You can either set up groups, assign users to them, and check access by group or you can set a table of users with fields for the forms and indicate t/f for each form for each user.

[Keith Hubert]

Re: difference password for each user to open the same form

Hi Peter,

One way is to set up User Groups.

On the button that is calling the form you can have a dialog box to advise user if they are not in an authorised group. The second instruction would be to open the form if the logged in user was in the authorised group.

To test you will need to use Xbasic something like this

is_one_of("Sales",user_groups())

That is if you had a group called Sales.

[peterth]

Re: difference password for each user to open the same form

Hi Stan,

Thank you for your advise.
If I have 2 forms ; cust_id and expense
and 3 users ; john, sarah, david

and allow them to user form like this

cust_id expense
john john
sarah
david
I mean cust_id form has 3 user can access and use it while expense form has just only john can access and use it.

what I have to do with cust_id and expense form?

if I crate a table and has field name contant the user name and another field for enable each form for t/f. I don't understand clearly for the other field to enable each form true/fault

table name auth has 4 fields ; user_id,user_name,cust_idform, expenseform

user_id user_name cust_idform expenseform
001 john t t
002 sarah t f
003 david t f

if I create the above table like that and how can I map this table to authorize user to use each form

Plase advise

Thanks
Peter-th

[peterth]

Re: difference password for each user to open the same form

Hi Keith,

Thank you for your advise.
I will try it again

Thanks
Peter

[Keith Hubert]

Re: difference password for each user to open the same form

Peter,

Here is working sample of how I have used the Alpha Security to control what department has logged on.

The password for Adminsitrator is admin. (lower case)

The passwords for the other users is on the Main Menu form.

Examine the form in design mode, see the calculated field. Take note of the conditional object and the expressions which control each layer.

Look at Tools->Security from the main toolbar.

As I said this is how I have done it, others may have another take on it.

[peterth]

Re: difference password for each user to open the same form

Hi Keith,

Thank you for your sample I will try and learn it to modify to my application.

Thanks again
Peter