Assigning value from one or another table
Hello Everyone
It's quite complicated question, but I will try to explained it.
Let say I have 3 Tables - 1, 2 and 3.
In table one I have a field, where the value has to be dependent from that, from what other table (2 or 3) this record was generated.
With other words - If i create a record in table 1 from table 2 - the field has to have a value A.
If I create the record in table 1 from table 3 - the field has to have a value B.
The A and B are existing values in tables 2 and 3.
1 reply
-
Are these tables linked with a reference field? That will make things easier.
If they are linked with reference fields then you do something like:
if table2 then "A" else if table3 then "B" endI've attached a sample DB. If you create a record from Table2 or Table3 to Table1 then the formula field will fill in accordingly.
The logic reads, if the field table2 has value then put the letter A, and if table2 has no value then check table3 if that has a value then show the letter B and if that doesn't have a value then show nothing.
Content aside
- 3 days agoLast active
- 1Replies
- 17Views
-
2
Following