Duplicate Field Names in Different Tables? 1

[hope2bDev]

My first real effort at designing a db is underway. Is it ok to use duplicate field names in different tables or will I run into problems later? Like:

tblCustomer
FirstName
LastName

tblEmployee
FirstName
LastName

Should I use longer field names? Like:

tblCustomer
CustFirstName
CustLastName

tblEmployee
EmpFirstName
EmpLastName

TIA
Steve hope2bDev

 

[BNPMike]

It's not a problem. If you use similar names Access will pre-insert joins in QBE which may save you some time. On the other hand you are always going to have to qualify field names when you have joins, but - particularly if you use QBE to create your SQL - that's not much of a burden.

 

[cgarts]

Hi,

For brevity and clarity:

CustName1
CustName2

EmpName1
EmpName2

What say?

C

 

[dhookom]

I have terrific luck with never repeating a field name within an application. My employee table would be:
[tt][blue]
tblEmployees
empEmpID autonumber primarykey
empFirstName
empLastName
empDOB
[/blue][/tt]
Each field name begins with 3 characters that describe the table. The first field is always duplicate codes followed by ID and is an autonumber primary key.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.