CB Query plugin not working like it used to?

   
Hi,
I am using cb_query plugin to query an external DB
Joomla 4 / cb 2.8.0 and cb query 6.0.2+ / php8.1
There are 3 fields
School Roll Number [cb_schoolroll]
School Name
School County

When a user enters the school roll > text field with query validation > Ajax = Yes
SELECT * FROM `aaa_schools` WHERE `schoolRoll` = '[value]'; 
This works and returns the success message.
I then want the School Name field to return the School Name based on the value enters in the School Roll:
SELECT `schoolName` FROM `aaa_schools` WHERE `schoolRoll` ='[cb_schoolroll]';
Previously I had this setup as a Query Dropdown and the result would appear.
However it now remains blank  / unselectable - how can i chain my queries using cb_query

You need to install CB Core Fields Ajax then edit your School Name and have its Update On set to cb_schoolroll. This will cause it to refresh when cb_schoolroll changes.