update problem in perform

Path: emory!att!pacbell.com!mips!think.com!zaphod.mps.ohio-state.edu!magnus.acs.ohio-state.edu!mtrotter From: mtrotter@magnus.acs.ohio-state.edu (Mark L Trotter) Newsgroups: comp.databases.informix Message-ID: <1991Nov18.212125.4570@magnus.acs.ohio-state.edu> Date: 18 Nov 91 21:21:25 GMT Sender: news@magnus.acs.ohio-state.edu Organization: The Ohio State University Nntp-Posting-Host: top.magnus.acs.ohio-state.edu In a perform screen how can you update a field that has lookup attributes to delete the current entry and not get an error about not existing in the lookup? In the example below, Joe blow once belonged to 3 deptartments, but has dropped out of one of them. I want to remove the current entry in field c and leave it blank (or null). I can't find a keystroke to do that. Fields d and e are empty and I don't get an error with them. in the screen section: Code Department name [a ] [aa ] [b ] [bb ] [c ] [cc ] [d ] [dd ] [e ] [ee ] in the attributes section: a = names.dept1, lookup aa = depts.name joining *depts.code; b = names.dept2, lookup bb = depts.name joining *depts.code; c = names.dept3, lookup cc = depts.name joining *depts.code; d = names.dept4, lookup dd = depts.name joining *depts.code; e = names.dept5, lookup ee = depts.name joining *depts.code; Mark Trotter (trotter.1@osu.edu)