Thanks for that.

Right I've now got the following statements to return the correct information in a grid.

Can anyone advise how to capture the returned data into output parameters ?

I am...

The main table will not necessarily hold englisg text. The text will be in the local language of the user who inserted the record. There will always be a pair...

The Popuptext required if there is no record in the Translation table is the one from the Main table record