Reference to Yes/No

[Madalin]

Hello. Please help me with a solution.

I have 3 tables with their names: A, B and C.
The columns of the tables are:
A: a_id (text), SAL1 (Yes/No), Company (ref to B)

B: b_id (text), Company (text), virtual column (REF_ROWS("A", "Company")) , virtual column (REF_ROWS("C", "Company"))

C: c_id (text), Company (Ref to B), SAL2 (Yes/No)

In table B, select Yes or No depending on the company.
For example, in table B, we have the following rows
1, Dianex, Yes
2, Farex, No

Please help me with the expression that I have to put in table C, column SAL2 in such a way that, if if
1. select Dianex, to automatically put in SAL2 (Yes)
2. I select Farex to put the machine in SAL 2 (No)

[WillowMobileSys]

---

@Madalin wrote:

Please help me with the expression that I have to put in table C, column SAL2 in such a way that, if if
1. select Dianex, to automatically put in SAL2 (Yes)
2. I select Farex to put the machine in SAL 2 (No)

---

In table C SAL2 column use this expression.  

[Company].[SAL2]

This is known as "dereferencing" a Ref column to get access to any of the columns on that ref row. You use "dot" notation to "dereference"

[Madalin]

Thank you for your help,

I get this error https://app.screencast.com/KDonXbWyabgfx