Subject function form_onNavigate(nWorkArea) From roy price <royprice@royprice.name> Date Mon, 10 May 2021 17:32:51 +1000 Newsgroups dbase.getting-started This one's a mystery to me. My main table cactusaa, I have linked to a table Cactusaatext that contains a field "rec" that is the same as the "rec" field in the main table. The fields were text 4ch, but I changed them to numeric, 4ch. this function (which I understand is the syntax for a numeric field) produces a "database engine error". function form_onNavigate(nWorkArea) this.cactusaatext1.rowset.applyLocate( "rec = " + this.cactusaa1.rowset.fields['rec'].value  ) But if I change it back to :- (Syntax for text field) function form_onNavigate(nWorkArea)   this.cactusaatext1.rowset.applyLocate( "rec = '" + this.cactusaa1.rowset.fields['rec'].value+"'"  ) This worked OK when the field was text, but now it still works, but only for when the contents of the field (4CH) are greater than "1000". IE, nothing under 1000 works. So I don't understand why the syntax for a text field partially works, but the syntax for the correct numeric field does not. Do I understand the syntax correctly  for each field type? Regards Roy Price