my question - i have created a created a custom record there are 29 body fields there by the help of schedule script i am inserting the data in those field this schedule script will execute data will be inserted by the save search i have created for that till here no issue but the next time i dont want to create the new record i want to update the existing record pls tell me how can i do that

If you are using SuiteScript 2.x then in your scheduled script, use record.load() instead of record.create()

Set a foreign key based on some (non changing) value from the search results