If you need any help with the example api let me know, annoyingly teams didn't record the audio and i haven't had time to re-record it along with the second version of the code we created

Thanks i had looked at the documentation the insert data from another table and the defining a table from another table. 

Yes the syntax wasn't quite like documentation (was solid normal sql syntax i think) . Still doesn't seem to like it via linked table 

ERROR #5475: Error compiling routine: %sqlcq.SRFT.cls301. Errors: %sqlcq.SRFT.cls301.cls ERROR: %sqlcq.SRFT.cls301.1(19) : <UNDEFINED>parseExtFromNode+1^%qaqcmx *mt("f","1^SAMPLE.TEST") :

Think linked table is external software running a cache db backend. It is IRIS for Health 2024 that is used as the TIE. 

The Foreign Table functionality is not free, it need to be part of the IRIS licence to allow you to use it, as i requested it and was told it would need added onto the licence to enable this feature.