Boy, This one just gets weirder. I created a very simple form with one variable lookup combo box that looks up the customer name from the customer table into vCustNo.
If I issue EDIT USING testcust from the R> I get the error (no rows found - 2059). But if I run it from the form designer it works fine. The problem appears global as none of the lookups work anymore so I'm thinking some sort of setting but when I compare the settings available from SHOW they all compare against the copy of the database that works. Jan
