Forum Discussion

Sachy123's avatar
Sachy123
Helper V
7 years ago
Solved

Need Help , lookup value from another table

In my scenario, I have two tables Contract Hierarchy ID ParentID ChildID 1 1 6 2 1 7 3 2 8 4 4 10 5 2 9 6 4 11 7 5 12 8 3 13 10 5 14 and ContractDetails ID Contractnumber 1 ABC1234 2 ABC1235 3 ABC1236...
Need Help
  • MFelix's avatar
    MFelix
    7 years ago

    Hi Sachy123,

     

    In my example I have the relationship with without bidirectionalty, using the both way filtering on relationships works in "stranges" ways.

     

    Regards,

    MFelix

MFelix's avatar
MFelix
Super User
7 years ago
Hi Sachy123, One point that I think I missed on your question you want to get the related ChildContractNumber or the parent ID on the ContractDetails? And what is the purpose? If you just need to create a table visual with that information having the relationship active between both tables is enough to make it work, you just need to use the fields where the ParentID is unique and then the ChildID field. Can you share additional information. MFelix