multiple entries

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

Guest

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?
 
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!
 
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?

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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top