0

Go to a specific record

Hi!

I have 4 tables:

TAB1 with the respective sub-table TAB4
TAB2 with the respective sub-table TAB3

Through the links I start from the N record in TAB1, I go to TAB2 then to TAB3 through various records.

In the record in TAB3 I inserted a button. Through this I would go to TAB4, leaving open the Record N from which I started.

What is the correct code?

Thanks

 

I attach app Ninox

4 replies

null
    • Fred
    • 2 yrs ago
    • Reported - view

    There is the openTable() function, but it will close the current table and go to the defined table.

    The only option to leave the current record open and open another is the popupRecord() function.

    • Rafael Sanchis
    • Rafael_Sanchis
    • 2 yrs ago
    • Reported - view

    Web Name

    Hi 

    I use this script and work fine, 

    let s := Week;
    let i := last(select Progress_Project where Week like s);
    openRecord(i)
    • Web_Namer
    • 2 yrs ago
    • Reported - view

    Thank you both for answering.

    Rafael

    I used your code and it works by adding closeAllRecords();, before openRecord(i).

    let s := Week;
    let i := last(select Progress_Project where Week like s);
    closeAllRecords();
    openRecord(i)

     

    Thanks a lot

      • Rafael Sanchis
      • Rafael_Sanchis
      • 2 yrs ago
      • Reported - view

      Web Name 👍

Content aside

  • Status Answered
  • 2 yrs agoLast active
  • 4Replies
  • 313Views
  • 3 Following