0

link two tables automatically

How to link records of two tables automaticly were table A and table B have a 1:n relations and one of the fields in A has the same values as one of the fields in B 

3 replies

null
    • Support
    • 5 yrs ago
    • Reported - view

    Hi,

    Here is how you can link related tables while importing data, https://ninoxdb.de/en/manual/import-and-export/importing-linked-data

    Read more about table relations here, https://ninoxdb.de/en/manual/tables/table-references-and-relations

     

    Regards,
    Sakshi- Ninox

    • rene
    • 5 yrs ago
    • Reported - view

    I want to enter a record in table 1, and than based on the input in a field automaticaly create a link to an excisting record in a excisting table. Is that possible?

    • Sean
    • 5 yrs ago
    • Reported - view

    If I understand you correctly, this should do what you want. I put this code in "Trigger after update" on Table1.

     

    let myTable1 := Id;
    let myText := Text;
    for i in (select Table2)[Text = myText] do
    i.(Table1 := myTable1)
    end

Login to reply

Content aside

  • 5 yrs agoLast active
  • 3Replies
  • 2493Views