Database engine cannot find record in the table!

[handlebars]

I have copied a template and tried to incorporate supplier ordering, by copying the tables relationships and forms exactly (apart from the appropriate names in tables and queries).

When I go to add a supplier order it gives me the error message "cannot find a record in the table 'suppliers' with key matching field(s) 'SupplierID'. I have exhasted all possible causes and am totally stumped after hours of testing. Can anyone at least point me in the right direction b4 i go mad!

ANdrew

 

[Darrylles]

Hi,

There is no 'SupplierID' field in the 'Suppliers' table that has a value that you are searching for.

You have some code that is looking for a SupplierID value in the Suppliers table.

Regards,

Darrylle

"Never argue with an idiot, he'll bring you down to his level - then beat you with experience." darrylles@totalise.co.uk