You wrote
>> Hmm, since you are using remote views, you have set the fields on the VFP end to nullable I presume... <<

When setting up a remote view, all I find are the standard query options which are not the same as locate tables. Where in VPP can I specify that a remote tables field values can contain NULL. I know where to do on the SQL server side.

Thanks,