* CLIENT table = (clientid (Ident),clntlastname C(40),clntfirstname C(40)) cLast="Smith" cFirst="John" OPEN DATA MyDataBase nCH=SQLCONNECT("conMyConnection") IF nCH= -1 WAIT WIND "Connect Error" NOWAIT RETURN ENDIF nA=SQLSETPROP(nCH,"Transactions",2) nS=SQLEXEC(nCH,"INSERT INTO client (clntlastname,clntfirstname) VALUES ('&cLast','&cFirst')") IF nS= -1 WAIT WIND "Execute Error" NOWAIT RETURN ENDIF nCS=SQLCOMMIT(nCH) IF nCS= -1 WAIT WIND "Commit Error" NOWAIT RETURN ENDIF *** Second connection nCH2=SQLCONNECT("conDUI") IF nCH2= -1 WAIT WIND "Connect Error" NOWAIT RETURN ENDIF nF=SQLEXEC(nCH2,"SELECT clientid FROM client WHERE clntlastname = '&cLast' AND clntfirstname = '&cFirst'","tabresults") SELECT tabresults BROWSE && Contains the new clientid