FIELDS ARE DUPLICATING!?!?

[xskaterboy]

I saw a tip somewhere that to create a form, that you should use data from a query? Is this true? Also the BIGGEST problem that I have is while entering info in the fields, I have "LAST NAME" from 3 different tables (and they each so happen to be the primary key) but what ever I type in the first box "Last Name" it automatically adds the same name in the other 2 "Last Name" Boxes! I have to have these 3 fields that have the same name but DIFFRENT names!!! How can I prevent this from happening??? HELP!!

 

[BNPMike]

...these 3 fields that have the same name but DIFFRENT names!!!

I think you've got the wrong forum. I suggest something more along the lines of... Tek-Tips.Philosophy.Existentialism

 

[dhookom]

When I create applications, every field name is unique. The first three characters of every field identify the table ie: tblEmployees with empFirstName, empLastName,... and tblApplicants with appFirstName, appLastName.

If you don't have this luxury, then you can alias your current field names in your query by creating columns like:
empFirstName: tblEmployees.FirstName



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

 

[BNPMike]

Last name by the way is not a good choice for a key for two reasons. The first is duplicates. Some time ago I was looking at the reason for slow running of a DB2 application. On inspection I found that one name appeared over 700,000 times. The second reason is names can be long and prone to mistyping.