I am using Version 8.2.0.1631.

When trying to save the DQL shown I am getting an error message referring to the user level (Which is high in this case) and I cannot see the relevance of the user level here - Any suggestions as to what might be happening?

We will need the application to have any educated guess. I was using the "exact" same DQLi.e. copy all from yesterday without any problems in the same version so this most be app specific. To make sure just make a simple sample and see if  you get the same problem then.

Here is a simple database containing just the forms referenced and any needed to satisfy relationships (The relationships also exist as in the original).  The username is Peter with no password.  Go into DQLs, load "pobtest" and try and save it.  I have had some problems producing this little database and I am wondering about the Vendor table in particular, but as yet I have been unable to pin the problem onto anything specific,

Regards

Peter

Sorry, should have spotted this on your first message but it is always easier when one can play with a sample.

"Can't see the forest for all the trees" is a saying and this is exactly what we have here.

for archive with (folio = any vendors folio) ;

modify records in archive

copy all from vendors .

end .

If you look at it with fresh eyes you will spot it yourself ;-)

This need to be either something like this:

for archive with (folio = any vendors folio) ;
modify records in Vendors
copy all from archive .
end

or if you want to achieve more or less the same as above i.e. modify archive it need to be:

for Vendors ;
modify records in Archive with folio = vendors folio
copy all from vendors.
end 

What you try to do is against the "rules" if you want to modify the current Archive record it would be:

for archive etc.
modify records

etc.

you cant modify records in Archive using a relational constraint as it would be re-entrant and you can't use a relationship that is not defined.

I am not sure what you try to do as your script would only run for one go and that is the one that match the first record of Vendors.