Help!

[Bachfile]

I'm pretty much a new MS Access user who's started a database for a small museum from scratch for storing artifact records. I have a field on my form for the donor of each artifact. The thing is, many people donate much more than one artifact, which means their name must be typed in the exact same way for Access to recognize it in a query.

Is there a way I can enter a donor's name, and have it stored in a way so that each entry adds to a name to the list in a combo box so when it comes to another artifact donated by the same bloody person, it just has to be selected?

thanks a heck of a lot.

 

[ColinEssex]

Hi

You need 2 tables. One for the donor and one for the artifacts.

Have the donor table with an autonumber as a PK then link the second table with that number.

What you have is a "One to Many" relationship - One donor can have many artefacts.

That way you only need to add the donor once when they are first registered. You could also have a subform on the donor form to list all the artefacts they have donated. But, I would suggest you start with the 2 tables first.

Post back if you need more help.

Col