Multiple 'First Name' (i.e.) Fields
Simple question probably simple answer. If I have a field 'First Name' in a Customers table and also in an employees table, am I looking for trouble? Should they be annotated such as 'C First Name' and 'E First Name' perhaps? Is there some other convention/method that I should be aware of?