Announcement

Collapse
No announcement yet.

App_Login reading users from two tables

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • App_Login reading users from two tables

    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.
    Albert Drent
    aducom software netherlands
    scriptcase partner, reseller, support and (turn-key) development
    www.scriptcase.eu / www.scriptcase.nl

    Comment


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

      Comment

      Working...
      X