joining tables

[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

 

[John Vinson]

would creating another table to show who's holding them be the
way?

current
userID
number
model

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