Reference id

YanChang · 08-25-2020 03:32 AM

Why doesn’t it work like that?

[Clients id] -> REF_ROWS(“Measurements”, “Client id”) - Measurements id
[Clients id] -> REF_ROWS(“Client diet”, “Client id”) - Client diet id -> REF_ROWS(“Monday diet”, “Client id”) - [Mondey diet id]

The first option works, the second doesn’t!
Where REF_ROWS(“Monday diet”, “Client id”) - [Mondey diet id]
works like -> REF_ROWS(“Monday diet”, “Client Surname”)

Why is that?)

Steve

You post makes no sense to me.

LeventK

@YanChang
May I suggest reading this post?

LeventK

@YanChang
It seems that you’re trying to establish a List Subtraction. Provided that’s the case, you are on the wrong path. Please take a look at these docs: