Let’s say the user is in a table called “Analyser”, where he/she selects a Surgery Title from a dropdown Enum column. There is a number type column called [Uneventful] in this “Analyser” table.
Now there is another data table with a lot of data already filled in called the “Surgery Logbook”. In that, there is a column called [Surgery Title] exactly similar to the enum column [Surgery Title] in “Analyser” data table. There is another column called [Complications] in this “Surgery Logbook” table which is populated with different values called ‘Uneventful’, ‘Grade I’, ‘Grade II’, ‘Grade III’, ‘Grade IV’ and ‘Grade V’. What I am trying to achieve is, when the user selects a [Surgery Title] in the “Analyser” table, the [Unevenful] column in that “Analyser” table to be automatically filled up with the number of ‘Uneventful’ occurrences in the [Complications] column of the “Surgery Logbook” table in rows where the [Surgery Title] is as same as the [Surgery Title] in “Analyser” table. These 2 tables are not referenced to each other so I was wondering whether a LOOKUP expression can bring this to work.
Would greatly appreciate if you could help with this! Thanks.