1) I should think those issues have been fixed.
2) "How could you tell which "John Davis" is which without the CPA license number"
I think that right there is the glue.
In the users table and in the table that the back end checkout for you mention inserts into, have a column for the CPA license number.
That will give you a unique value in both table to join on.