>At present the <3 is in the froms cursor filter, which means that the form loads 180 records more than it uses ( force = 3 = civilians) As I said, I should be able to set most default limnits on the server, i.e. 414 Sqn where uic_seq = 7, it is just a matter of figuring out how Oracle does it instead of the way Sybase or MS SQL do it (very easily).
>I am still left with, how to I tell the form.dataevironment which parametised remote view to load into its cursors?

You would have to abandon the dataenvironment.