Skip to main content
Database Administrators

Return to Question

Relevant tags.
Link
MDCCL
MDCCL
  • 8.5k
  • 3
  • 31
  • 62
improved formatting
Source Link
Hannah Vernon ♦
Hannah Vernon ♦
  • 70.5k
  • 22
  • 177
  • 321

I am creating a database in MS Access that has 3 different tables with 3 separate types of information for one set of users, Personal, Business and Board. 

I have one table created with all the users and a unique ID for each. 

How do iI link up the other 3 tables with the unique ID so the correct information is linked up to each user in each of the tables.?

I understand setting relationships, but can't figure out to what field iI link up the ID field in the users table to the other tables.

I am creating a database in MS Access that has 3 different tables with 3 separate types of information for one set of users, Personal, Business and Board. I have one table created with all the users and a unique ID for each. How do i link up the other 3 tables with the unique ID so the correct information is linked up to each user in each of the tables. I understand setting relationships, but can't figure out to what field i link up the ID field in the users table to the other tables.

I am creating a database in MS Access that has 3 different tables with 3 separate types of information for one set of users, Personal, Business and Board. 

I have one table created with all the users and a unique ID for each. 

How do I link up the other 3 tables with the unique ID so the correct information is linked up to each user in each of the tables?

I understand setting relationships, but can't figure out to what field I link up the ID field in the users table to the other tables.

Source Link
Dennis Villa
Dennis Villa
  • 1
  • 1

Linking tables in Access with unique ID

I am creating a database in MS Access that has 3 different tables with 3 separate types of information for one set of users, Personal, Business and Board. I have one table created with all the users and a unique ID for each. How do i link up the other 3 tables with the unique ID so the correct information is linked up to each user in each of the tables. I understand setting relationships, but can't figure out to what field i link up the ID field in the users table to the other tables.