Connecting Tables

[NewEra]

I'm having a problem in Access where I'm trying to connect 2 tables together.
On one table is all the information of the person, the other table is a list from 1-50. That list is a drawing of all the peoples ID number for a drawing. When I type in their ID next to what order they got picked in is there any way where All of their information comes with that ID number they have? I really need help on this.

 

[rbrady]

I’m no expert, but I'll give it a shot:

1. Your Person table probably has stuff like a name and address—does it also have an “ID” field? This field would be of autonumber data type and also the primary key of the table.
2. In your DrawingNumber-type table, you then need to add a field that will mirror the “PersonID” field from the Person table. Add this new field with an integer data type.
3. To connect the two tables, you create a relationship between the two. I don’t know the context, but you probably want a one-to-one or a one-to-many relationship.

When the tables are connected the way you want, you can bring the information together with a query.

I’ve found the Access help files and these two pages to be helpful, too:

• Database design basics (also available from the 2007 help files, I think)
• Fundamentals of Relational Database Design

I hope that helps!

 

[NewEra]

Thanks for the help, I'll look at the examples.