Software

Ask something
Question Locked

Access MC C Problem

0 helpful
3 replies

by maxpowers410

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi Guys,
Am makeing a new database with access. I remeber being good at it in school, and I really enjoy it. However I cant rember one small thing, I want to have one table whos PK is linked to severl FKs of a different single table.
E.G.: Table Friend: Stefan, Nigel
Table Hobbies: Swimming, Fishing, Kickboxing, Guitar.

Now if I want Stefan to have more than one hobby, how do I do that??

Thanks
Max :)

3 replies

by shellbot

make a couple columns in the Friend table.
Hobby1, Hobby2, Hobby3

Insert ID from Hobbies table into the cols?

Or are you thinking of doing it some fancy pants way?

by john.a.wills

Introduce a table PersonsHobby with columns
personID aznd HobbyID. You can put it as a scrolling subform on your main form.

This discussion is closed to new replies.