- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
re: Any Microsoft Access Experts?
Posted on 1/17/14 at 1:10 pm to TheOcean
Posted on 1/17/14 at 1:10 pm to TheOcean
Presumably you are using a form to add the people by name to the other tables. Have a dropdown list with their names in it and the ID (you can do this by query). Bind the list to the ID and use column width to hide the id in the drop down. The user will be selecting the name but the form will store the id.
Posted on 1/17/14 at 1:14 pm to Tortious
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.
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.
This post was edited on 1/17/14 at 1:15 pm
Popular
Back to top
Follow TigerDroppings for LSU Football News