Need help connecting multiple tables in a form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

This is what I am tring to do. I have lets say about 8 tables. I have one
table that has everyone in it but just names no data. Then I have 7 other
tables that have subject each person is good at and they are ranked. So a
person could be on multiple tables. What I want to do is create a form that
I can use a pull down box and have what subjects they are good at pop up.
For example I have the form made and I have the persons name box and the 7
empty feilds when I select the users I want to have the subjects that person
is ranked in to show their rank int he box that their are ranked in. Can
anyone help me (sorry for the mispellings.lol)
 
Sounds like you did not follow normal database design standards.

You should have:
one table with names
one table with all the possible subjects
one table to indicate who has which subjects

This is a classic many-to-many database design.

Your current design means that a new table has to be built if a subject is
added. It also means the tables, queries, reports, etc would need to be
updated to unclude the new table.

I'd recommend you follow normalized design and you will have much better
luck here.


Rick B
 
After rereading your post, I may have mispoken. I did not catch the 'rank'
part.

I still think it would be many-to-many, but we'd have to throw the 'rank'
into that third table.

Table1
Name

Table 2
Subjects

Table 3
Name
Subject
Rank
 
My problem is that I got this data from a web page. For example a sports
page. If I take the top 25 point scoers I copied and pasted them into the
points table. THen I took the top 25 rebounders. Then I did that for the
rest of the cat. then took the tope 150 players and that is a table. I want
to be able to see the top 150 players and go accross and see if they rank and
if so how high in each catorgory. THanks again rick
 
Back
Top