re: Any Microsoft Access Experts?

Maybe I should have been more specific/clear. Here's the best way I can describe what I'm trying to do:

I have a main database with all of the alumni information and then 4/5 separate tables for different competitive teams. I have a form for the database where the user will enter all of the alumni info and then click yes/no if the alumni competed on a certain team. From there, the user will then go to the table where the alumni competed and then enter in the competition, place, etc. Thus, I need the unique ID from the alumni main database to transfer to the competitive team table when the user clicks yes/no for a certain team.

I think the answer to the question has to do with foreign keys, but for some reason, when I use a foreign key, none of the data is transferred from one table to another.