Okay...you are right. So I'm back at square 1 again. because it is geared to be a multi user app. I was using the setup table to simple grab the next record id to assign a new entry, no matter what the table is bcause updates are made to varoius tables..