You cannot have two fields with the same name in one table, but there is absolutely no problem with having two fields with the same name in two different tables. You can certainly have a LastName field in the Patient table and a LastName field in the Staff table. Of course, if you wish, you can also make up different field names like PatientLastName and StaffLastName. The choice is yours. There are pros and cons of both naming conventions.