joining tables


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
 
Ad

Advertisements

J

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

joining tables 6
Join tables in Access 2
join 3 tables 0
Joining Tables/Queries 1
Join table and subforms 0
Problem joining two tables 1
Join two tables with an expression? 1
Joining Tables Vlookup equivalent? 1

Top