joining tables

  • Thread starter Thread starter nevje
  • Start date Start date
N

nevje

total beginner, access 2000

im starting a database of mobile phones, numbers and users - basically i
manage a couple of hundred or so mobile phones, sim card numbers and
current user details and would like to build a history to a number as
people join/leave, etc.

ive started with 3 tables:-

users
userID
username1
username2

numbers
number

models
model

i think the above keeps data from being repeated but for what i want i
think i need another table. one to show who is holding which phone
number and model. if i use the same names for the columns should i link
them using relationships, im a bit confused on this part to say the
least. would creating another table to show who's holding them be the
way?

current
userID
number
model
 
would creating another table to show who's holding them be the
way?

current
userID
number
model
Click to expand...

Exactly so. You'ld create a Relationship from UserID to the user
table, and from Number to the phone table, relational integrity
enforced.
 
Back
Top