How do I assign a value in one column by filling a...

Eduardo_dos_San · 08-01-2019 08:44 AM

How do I assign a value in one column by filling another column in another table?

LeventK

Can you please elaborate?

Bellave_Jayaram

Do these two tables have a parent / child relationship?

Eduardo_dos_San

I have two tables. 1 and 2

Table 1 is a complete list of machine at a given location.

Table 2 is where I say if one of these machines had a problem.

The problem I want to appear in table 1

It’s possible ?

Steve

Create a virtual column in Table 1 called (e.g.) Problem with the app formula:

ANY(
  SELECT(
    Table 2[Problem],
    AND(
      ([Local] = [_THISROW].[Local]),
      ([Machine] = [_THISROW].[Machine])
    )
  )
)

Or if you use @MultiTech_Visions’ suggestion, instead use as the app formula:

ANY([Related Table 2s][Problem])

MultiTech

I see where you’re going with that @Steve, I would actually nix the ANY() from that formula, and instead leave the column as a list of the related problems.

MultiTech

Create a reference in Table 2 to Table 1. This will create a list of related records from Table 2 inside Table 1.

This might help:

pbalerio

I guess this article might be of some value to you.