Form question

[Miethr]

I am trying to create a form that updates numerous tables.

I would like to be able to input a name and list sports that the person plays
(this is purely an exercise for me to learn access) so it would update two tables one like this

ID Name
1 Riley
2 Jeff

the other that it is linked to by ID number (hidden)

Name Sport
Riley football
Riley Soccer
Jeff Football
Jeff Ultimate frisbee


I don't know how to make a form to input data so it can be shown in a table like this. I am doing this in part because I learned about normalization and want to increase my knowledge of how to make it work.

any help/examples would be great,

Thanks
Riley

 

[KenHigg]

If I'm understanding what you are trying to do; First your two tables need to be set up with the obvious 1 to many relationship. Then you can do a form / subform to input the data, basing the main form on the one side table and the many side table is used in the subform...

Edit: I just posted a sample - see if this helps (It is post #19):

http://www.access-programmers.co.uk/forums/showthread.php?t=99777

 

[Miethr]

Ken

that makes sense, I was wondering, when I build the relationships...what does it mean for referential integrity and how would it be used or would it be needed, the help section doesn't do much for me on this.

thanks.

Riley

 

[KenHigg]

It basically means if you change something on the one side it will change it on the many side automatically. Say if you delete a name (record) in it will automatically delete all of that name's records on the many side...

There's a little more to it than that but you get the point...

 

[Miethr]

sample

Ken, I get the idea, but my logic is still out of place as to how to link. Below is the DB I am started. Take a look. I want to be able to select a dot and then if the dot is selected then on query it will show

Riley Football
Riley Soccer
Jeff ultimate frisbee

i realize this will need an if yes show "football" or whatever on the table design

but I just can't make the connection as to what the record source is for the sub form.