0

Select a Record from a subtable to reference in main Table

Hello i trie to select with A Button and a text field a record from a other table.

with the text in field text an then Button i would likte to have the Record seleted in Referenced Table "Articlelist"

 i tried this:  

let mysearch := text;
Articlelist = (select Articlelist where Partnumber = mysearch)

 

but nothing happens....

any Ideas?

1 reply

null
    • Fred
    • 2 days ago
    • Reported - view

    I'm guessing that Articlelist is a dynamic field.

    Whenever you do a select, Ninox always returns an array, even if only 1 record is found. So you need to wrap your select with a first() or last(). Then you need to wrap all of that with number(), because a select returns a nID which contains the table identifier. Then if you are modifying the Articlelist field you need a colon in front of the = to tell Ninox you want to modify the field.

    let mysearch := text;
Articlelist := number(first((select Articlelist where Partnumber = mysearch)))
Login to reply

Content aside

  • 2 days agoLast active
  • 1Replies
  • 17Views
  • 2 Following