0

Views

I have a PROJECTS table with 2 subtables CONTRACTS and SOLUTIONS.

I would like to show a View in SOLUTIONS, showing the CONTRACTS - but only the ones related to the current PROJECTS

 

How do I write the code in the View.....: select "and then what"

 

Any ideas? 🙏😊

3 replies

null
    • Ninox partner
    • RoSoft_Steven.1
    • 2 yrs ago
    • Reported - view

    JJ,

    let me := this.PROJECTS;

    select CONTRACTS where PROJECTS = me

    Steven

    • KAXIG ApS
    • John.1
    • 2 yrs ago
    • Reported - view

    Excellent Steven, thanks 

    / John

    • Alain_Fontaine
    • 2 yrs ago
    • Reported - view

    Since there are relations in place between the tables, it should be possible to fill the view by navigating those relations instead of resorting  to the almighty 'select' function. From "SOLUTIONS", one can navigate "up" (N:1) to the corresponding record in "PROJECTS", and then "down" (1:N) to the records in "CONTRACTS". The formula to fill the view - if the reference fields have not been renamed - would then be:

    PROJECTS.CONTACTS

Login to reply

Content aside

  • 2 yrs agoLast active
  • 3Replies
  • 223Views