Rollup/Lookup returns all CBM values instead of single one

[Kristaps_Lagzdins]

Hi everyone,

I’m building an app to calculate log weights inside containers.
I have two tables:

• CBM Table – contains CBM values for each Key = Diameter + Length.
• Koki Table – each row is a log, with a Key column that should match exactly one row in the CBM Table.

I created a Relation (CBM Ref) between Koki.Key and CBM.Key.
That works — it finds the correct match (e.g. 20 - 4000).

Problem:
When I create a Lookup or Rollup, it shows all values from the CBM table instead of just the one that matches.
For example, instead of just 0.147, I get {0.047, 0.052, 0.061, 0.069, 0.147, …}.

I expected only one value, since the key is unique.

Question:

• Why is Glide not returning only one row from the relation?
• Do I need to change data type (number vs text)?
• Or is there some trick with Rollup → “Single value” to only return one CBM?

Thanks in advance

Pictures of my tables:

[Darren_Murphy]

Are you sure you are targeting the relation correctly?
Can you show how your CBM lookup is configured?

[Kristaps_Lagzdins]

You mean this one?

[Darren_Murphy]

Yes, that’s the problem. You are targeting the CBM column through the table, instead of through the relation, essentially ignoring the relation. Change that and you should get the result you are expecting.