set first and last name edit box data source to the appropriate fields in Table2
put the following code in CID# edit box LostFocus code

sele table2
seek allt(this.value) [or Upper(allt(this.value), depending on key]
If !found()
wait wind "CID# not found" NOWAIT
NODEFAULT &&will prevent the focus from leaving the entry box
Endif
thisform.refresh &&will update the display of field values

Of course, you'll probably modify a lot of this to fit your app.