>>I cannot setup SID as a primary key as the table also has some potential students who do not have SID yet. You could set an index for the table allowing nulls but not duplicates. -- KARL DEWEY Build a little - Test a little "Song Su" wrote: > I have a form that user often carelessly entered duplicate SID (student ID, > text type). I cannot setup SID as a primary key as the table also has some > potential students who do not have SID yet. > > I want the form to pop up, when duplicate SID entered, a window saying that > SID already exist. Click OK to jump to that record, or Cancel to stay in > this record, not saved. >
