Can Name Candidate No Subject No Mark Remark ____________________________________________________________________ Jack 6100 12345 70 Mary 6102 10456 88 John 6161 12345 70 A table is demonstrate above and store noted ADOTable1 Now data is entered in the 5 Tedits Can_Name: Jack Candidate No: 6100 Subject No: 12345 Mark: 70 Re-mark: 99 (This data should be added to the table) What is the syntax using the 4 Tedits above to locate and select the record in the table and add 99 to the (Remard field)? This is really hard for me

using all 4 fields to locate : if ADOTable1.Locate('Can Name;Candidate No;Subject No;Mark', VarArrayOf([Edit1.Text,Edit2.Text,Edit3.Text,StrToInt(Edit4.Text),[loCaseInsensitive]) then ADOTable1.FieldByName('Remark').Value := Edit5.Text; **If your Candidate No / Subject No is integer, you have to use StrToInt as well. BUT, if your Candiate No Subject No is unique (primary key?), you should only use that 2 field to search instead of all 4 field.