Skip to main content
To homepage To homepage
Solved

Add related records, no relation between tables

  • September 13, 2021
  • 3 replies
  • 77 views
M
Contributor

I am unable to use the Add related records on a table. I get the error message "There is no relation between table-A and the table table-B".

I have added a condition where the key in both tables should be equal. I have also tried creating a relation between the two tables in both directions but no luck.

There is no mention in the docs that it is needed to add a relation before adding related records.

I am getting a Warning that the source table is executed after the destination table.

What am I doing wrong?

Best answer by Thomas Lind

Hi Martin

While the guide does mention relations, it does not show what you need to do to set these up.
Like so

When you try to find the one that is related you get the same view, but need to scroll down to find the correct field to join with.

 

View original
    P
    1 person likes this
    • P
      pkaustubha
    Did this topic help you find an answer to your question?

    3 replies

    M
    Contributor

    Might be worth mentioning is that table A is filled by a table insert from another table.

    M
    Contributor

    Solved it my self! I just hadn't scrolled down to table B in the Conditions window. So I had a condition saying table_A.key = table_A.key.

    Thomas Lind
    Community Manager
    Forum|alt.badge.img+5
    • Thomas Lind
    • Community Manager
    • 1017 replies
    • Answer
    • September 14, 2021

    Hi Martin

    While the guide does mention relations, it does not show what you need to do to set these up.
    Like so

    When you try to find the one that is related you get the same view, but need to scroll down to find the correct field to join with.

     

    daniel
    1 person likes this
    • daniel
      daniel

    Reply


    Most helpful members this week

    Terms and ConditionsCookie settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie settings