Forum Discussion

aziemlewicz's avatar
aziemlewicz
Registered
17 hours ago

Formula to lookup value in another related table

I have a lookup table that has a relationship with 2 other tables (Table 1 & Table 2). There are 2 different IDs in my lookup table that I need to check in Table 1 & Table 2. I need to check Table ...
i'm new
Denin's avatar
Denin
Qrew Assistant Captain
17 hours ago

I think there's more than one way, either with formula or summary fields.

So you have Lookup Table (A), Table 1 (B), and Table 2 (C).

I guess you have A as parent of B and C. A has or should have a lookup field from B and C for their respective IDs.

Then you use a formula like this in new formula checkbox fields in A:

- if [ID B] has any value, return true
- if [ID C] has any value, return true

How exactly to check if the ID exists depends if it's a number or text, or what it is exactly. Assuming it's just numbers, you can do it like this:

not IsNull([Name of Field With B's ID])