App_Login reading users from two tables

Applications Control
#1

Hi all,
I wonder if there is a possibility to check user login looking into two tables.

I got customers as users that have to login and obviously they have only to access to their data .
In customers table I got login’s user and password and then I use [glo_CustomerID] in every WHERE table condition to filter data.

On the other side I got Salesmen that need to have the possiblily to check orders and data of several customers connected to him.
On the Salesmen table I got login’s user and password too.
When I login as Salesman then I use [glo_SalesmanID] within WHERE condition in order to show him all customers followed by him.

Is there a brilliant solution to achieve that ??
Any suggestion and hint are welcome !!!
Bye
Gi?

#2

Yes you can, but you need to change the generated code of the login application. You can add a dropdown asking for the role (customer / sales) and use that to select the authentication on the right table.

#3

Hi Albert,
many thanks !!!
It would be a brilliant solution !!!
Bye