How can I Retrieve column iD after "Valid If" conditioning for Dependent Dropdowns?

[integraOdontoSj]

Hello, guys,

I have managed to create a dependent dropdown using the "valid if" method.

In this pic, you can see columns 4 and 5 as "Enum", where I put the values I wanted to retrieve and reference in the "Valid If" field.

It worked, however, this does not give me the "Id" of the source table's row I was looking for. Instead, it just retrives me the name of the item I was looking for from category X.

The problem is that now I need to get other information about that item, that I could easily get with a lookup formula, but since I'm working with the item's name, it won't necessarily be unique, rendering the lookup formula not viable.

Is there any workaround that? I could not think of any, at least until now.. 

[dbaum]

I don't follow your explanation. It sounds like you need to configure one or both of the columns you cite to reference another table. You can either make them Ref type columns or Enum type with a base type of Ref.