0

Table Constraints

I am trying to create a table constraint. 

 

I have a table named transaction, with a debit account, and a credit account, to move money from one, to the other.

 

In the accounts I have a users field named "Ninox User" in the debit account, I want the constraint to only show the accounts of the user logged in.

So I am doing:

a.'Debit (From Account)'.'Ninox User'=

 

but what do I put for it to equal the current user?

3 replies

null
    • SMoore
    • 5 yrs ago
    • Reported - view

    Bump

    • Alexander_Koenig
    • 5 yrs ago
    • Reported - view

    Hi, we just started a SIG (special interest group) on accounting. This is a weekly regular webinar. 

    https://zoom.us/webinar/register/WN_ETLUOTkqR3OVdve_Qe1Qug

    • Alexander_Koenig
    • 5 yrs ago
    • Reported - view

    actually you can try:

    user()

    This returns the logged in user.

Content aside

  • 5 yrs agoLast active
  • 3Replies
  • 2235Views