You need to pack your indexes and keys, Jan. Better yet, reload the
database.
Albert
jan johansen wrote:
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
