Advertisement
- Home
- Microsoft
- Development
- MS Access
- How To Set up Form for Many to Many Relationship & then Correctly S...
Advertisement
- 1. capricorn1 3,083,889
- 2. DatabaseMX 2,294,793
- 3. LSMCons... 1,210,599
- 4. boag2000 936,219
- 5. peter57r 775,749
- 6. GRayL 640,864
- 7. harfang 487,606
- 8. matthews... 464,024
- 9. cactus_d... 412,144
- 10. jimhorn 380,217
- 11. hnasr 273,614
- 12. TextReport 247,857
- 13. puppydog... 243,420
- 14. jimpen 237,831
- 15. mbizup 234,042
- 16. tbsgadi 218,162
- 17. angelIII 213,704
- 18. JDettman 200,360
- 19. LPurvis 187,473
- 20. irudyk 184,929
- 21. ee_rlee 173,155
- 22. Natchiket 172,413
- 23. jefftwilley 162,635
- 24. omgang 157,715
- 25. hielo 144,621
- 1. capricorn1 10,740,927
- 2. nico5038 5,704,781
- 3. rockiroads 5,464,025
- 4. peter57r 4,220,244
- 5. DatabaseMX 4,178,254
- 6. LSMCons... 3,947,189
- 7. LPurvis 3,446,440
- 8. shanesue... 3,288,317
- 9. harfang 3,104,439
- 10. stevbe 2,860,011
- 11. GRayL 2,800,708
- 12. jimhorn 2,799,809
- 13. mbizup 2,120,632
- 14. flavo 2,112,583
- 15. jadedata 1,964,977
- 16. jefftwilley 1,822,075
- 17. matthews... 1,801,237
- 18. thenelson 1,700,369
- 19. boag2000 1,618,963
- 20. eghtebas 1,493,929
- 21. puppydog... 1,422,883
- 22. cactus_d... 1,384,933
- 23. dannywar... 1,321,476
- 24. Arthur_... 1,311,584
- 25. jjafferr 1,276,957
| 02.21.2008 at 05:42PM PST, ID: 23183306 |
|
[x]
Attachment Details
|
||
|
[x]
The Solution Rating System
|
||
With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.
Your Input Matters If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support. Thank you! |
||
How To Set up Form for Many to Many Relationship & then Correctly Store Gathered information
Asked by Sunrize555 in Microsoft Access Database, Access Forms
Tags: Microsoft, Access, 2003;2007
For the data entry form, I want to enter in Student ID (is already auto number), Student Last and First Names, Cell Phone Number and Carrier. Then I also want to be able to select one or more courses from the course table. I want to then be able to store this gathered information in the correct tables.
So now I have gathered the student info and certain info from the course table.
Where I am stuck I understand that the first five fields will update the student table, but Im not sure where the one or more courses that the student selects, will get stored. I can almost see most of you groaning, but Ive been at this for two days AND nights (well, working 8 hours a day at a job too), trying to figure out how to set up the form. I think it may have to do with setting up an update query in the form? That would update the student course link table?
I feel as though this is simple, but I just am just missing a piece of the puzzle. I am a beginner with Access, and athough Ive looked in at least all over, I cannot find an example of how to tie in the tables with the linking tables, so that I can enter in everything I want to on the form, and have what is gathered on the form get stored in the tables correctly, so that when I run queries or reports, I will see the student information and the courses they are currently taking. I feel that my tables and relationships are set up correctly, see attached. Once I can understand how to set up the form for gathering the student information, I will be able to set up something similar for the Instructor. Thank you so much for your help. I can also manage to put in code on the form property if that's what is needed. Id like to get some sleep soon. Sunrz
Start Free Trial
