multiple entries

Î

ÎικDoc

I would like to have multiple entries for one person . I want to add new
entries to the old ones without erasing the old ones. How can I do this with
Access?
 
C

Chaim

If you're adding to a Datasheet view of the table, simply put your cursor in
the row at the bottom of the datasheet and enter the data for the person.

Is there more to this question? This is, as DL pointed out, very basic. How
did you get the original entry for the person into the table? How did you add
entries for other people? Are you perhaps running into problems entering
non-unique records?

I'm just grasping here, trying to get at what the real question might be.
Help us out. People here are willing to help, but we aren't going to do your
legwork for you.

What Access book(s) are you using?

Good Luck!
 
J

John Vinson

I would like to have multiple entries for one person . I want to add new
entries to the old ones without erasing the old ones. How can I do this with
Access?
Click to expand...

What is an "entry" in this case?

You perhaps should consider having two tables in a one to many
relationship. If a "entry" is some sort of repeating information about
a person, you would have one table (People) for the static
biographical information, related one-to-many to a second table
("Entries" maybe??). A Form based on People with a Subform based on
Entries is a convenient user interface for this purpose.

John W. Vinson[MVP]
 
Top