How do I keep from repeating one entry like the same name, info. .

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

An example would be a person with the same, but he has two or more entries of
information.
 
Not sure what you are asking. You need to spell out your question in full
sentences.

If you are saying that you have multiple records with the same customer, or
employee, etc. Then you would use multiple related tables.

You might have one table with:

CustomerTable
CustomerNumber
CustomerName
CustomerAddress
CustomerPhone
Etc.

Then another table where you store each sale or transaction...

TransactionTable
CustNum
Date
Amount

Then, you would build a relationship between the tables so that
TransactionTable.CustNum is linked to CustomerTable.CustomerNumber. This is
a classic one-to-many relationship and the whole reason behind relational
database design.

Rick B
 
An example would be a person with the same, but he has two or more entries of
information.
Click to expand...

Typically you would design your database with two (or more) tables -
e.g. a table of People linked one-to-many to a table with the
additional information.

If you'ld like a more detailed answer... please ask a more detailed
question!

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Back
Top