- 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 12:29 pm to Breesus
Posted on 1/17/14 at 12:29 pm to Breesus
I got stuck with a campus job trying to design a database, so I've been teaching myself from scratch. I have the framework built, I'm just missing one very important concept.
Let's say you have the main database with alumni, and then you have 4/5 other tables for competitive teams that represent the university. How can I automatically transfer the unique alumni ID from the main database to the separate competitive teams tables?
If that isn't clear I can try to make it clearer
Let's say you have the main database with alumni, and then you have 4/5 other tables for competitive teams that represent the university. How can I automatically transfer the unique alumni ID from the main database to the separate competitive teams tables?
If that isn't clear I can try to make it clearer
Posted on 1/17/14 at 12:31 pm to TheOcean
like...you want to copy records from table 1 to table 2...or you want to reference the information in table 1 in table 2?
Posted on 1/17/14 at 12:31 pm to TheOcean
quote:
How can I automatically transfer the unique alumni ID from the main database to the separate competitive teams tables?
You mean from excel to access or from one database in access to another one?
Posted on 1/17/14 at 12:32 pm to TheOcean
quote:
Let's say you have the main database with alumni, and then you have 4/5 other tables for competitive teams that represent the university. How can I automatically transfer the unique alumni ID from the main database to the separate competitive teams tables?
We talking vlookup here?
Posted on 1/17/14 at 1:29 pm to TheOcean
I suggest that your either 1. study relational database theory/understand the relational model or 2. if you are not willing to invest in this learning you might be better off just using Excel.
Popular
Back to top
Follow TigerDroppings for LSU Football News