HELP WITH DUPLICATES!!!!

[xskaterboy]

HELP!! I have a form that has DUPLICATE field names from different 3-4 different tables ie: Last Name, First Name, Address, etc. When entering the data it changes ALL the fields that have the same name! ie: Last name= Smith Last name= Johnson Last name= Shattuck .....Then they ALL change to the same last name! I tried to use 3 different tables to make this form. The someone told me to use a query using to build the form, would it be that in all 3 tables the primary key is set to LAST NAME? Help bfore I go bald!

Appricated very much....

 

[SteveR77]

More detail is needed to help you with this.

It sounds as if you have joined all the tables or set up an update of some kind.

More to the point. Why are there three tables?

Why not a single table that has the fields for your last name, first name, etc. ?


Thanks,

Steve

 

[xskaterboy]

Here is the form in a nutshell: I need 3 sections; Renters info, Drivers info, other vehicle drivers info. Since section has duplicate fields like: LastN FirstN Address City Zip DOB License# etc. are all duplicate info with seperate data, don't I have to use 3 seperate tables so that the questioning does not clash?

 

[SteveR77]

No, you do not have to use 3 tables to get what you want.

However, in either case if you use a single table or if you have multiple tables I would make the names unique.

Renter-FN, Driver-FN, etc. having a naming standard is important because it helps with documenting and supporting your application. Especially when their can be duplicate names to describe a field.


Steve

 

[xskaterboy]

Thank you! I just tried it an it worked!! Now This is a very intense database that I am trying to create, can I do all my fields (about 200+) with just one table? and if so does that defeat a purpose to relationships? Or when is is a good idea to use more than 1 table?
Thank you for ANY advice.....VERY MUCH!

 

[SteveR77]

Creating a flat file relational database is a very bad idea.

Take a look at the following information on database normalization -

http://support.microsoft.com/?kbid=209534

I would also recommend taking a look at the other information under the Basics here as well -

http://www.kayodeok.btinternet.co.uk/favorites/kbofficeaccess.htm

I will hopefully save you from some nightmares later on.


Steve

 

[xskaterboy]

Thank you so much..... The information was very helpful!