Build an Inline view with the values from an EnumList self refferenced

I have two tables: bloodtypes and donors
bloodtypes:
key = number (1 to 8 representing A+,A-,B+,B-,O+,O-,AB+,AB-)
donors =Enum List type ref to bloodtypes table (Example; A+,A-,O+,O-)
recepients = Enum List type ref to bloodtypes table (Example: A+,AB+)

donors:
name,phone,bloodtype

For each blood type I have the lists of recepients alredy and I have another table called donors that have the name, phone and blood type of the donor

Iโ€™m looking to build an inline view of donors displayed in the detail view of a row in bloodtypes so that when I select for example row A+ it will show me all the donors compatible with A+ filtered with the EnumList of referenced from the column [donors]

Solved Solved
0 2 336
1 ACCEPTED SOLUTION

Steve
Platinum 4
Platinum 4

Like this?

FILTER(
  "donors",
  IN([bloodtype], [_THISROW].[donors])
)

View solution in original post

2 REPLIES 2

Steve
Platinum 4
Platinum 4

Like this?

FILTER(
  "donors",
  IN([bloodtype], [_THISROW].[donors])
)

Perfect!

Top Labels in this Space