Jess,

I have already done this a temporary "quick and dirty" fix, but I really don't like creating public variables at all, ever. I appreciate the response an this does work, but I was looking for something at little tidier (this seems to be a classic example of using a sledge hammer to crack a nut and is really only tackling the symptoms rather than the problem).

There must be another way around this problem!

>>USE DBname!RemoteViewName NODATA &&-Parameterised
>>USE DBname!LocalViewName NODATA &&-Not parameterised
>>
>>As soon as the second line is run it asks me for the order_id that the remote view needs to retieve order lines! Am I doing something wrong? Is this a bug? Is there a workaround?
>
>Make nOrder_id as PUBLIC variable and initialize it to 0.