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! Go to Solution.
Like this?
FILTER(
"donors",
IN([bloodtype], [_THISROW].[donors])
)
Perfect!
User | Count |
---|---|
44 | |
28 | |
28 | |
21 | |
13 |