 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / March 2007Form data
I notice that in a Form that inputs to various tables that only certain records are 'viewable' when scrolling back/forwards - why would this be? Many thanks in advance. Martin Martin A form in Access only shows what its underlying record source allows it to show. What is the source for your form? Regards Jeff Boyce Microsoft Office/Access MVP >I notice that in a Form that inputs to various tables that only certain > records are 'viewable' when scrolling back/forwards - why would this be? > > Many thanks in advance. > > Martin Jeff Thanks for getting back to me. The form is 'queried' to; SELECT Students.[First Name], Students.Surname, Students.[Tel No], Students.[Mobile No], Students.DOB, Students.Comments, Preferences.[Pref Day], Preferences.[Anticipated Level], Preferences.[Pref Course] FROM Students INNER JOIN Preferences ON Students.[No]=Preferences.ID; If I input a number of records it appears only certain ones (and always the first one) appear. > Martin > [quoted text clipped - 12 lines] > > > > Martin I'm not sure why only the first one would show, but the SQL statement includes an Inner Join. If there are no "matching" records in the Preferences table, the query won't return any student data. I'm a little unclear on the structure and relationship of your tables. From the SQL statement, it looks like you have a one-to-one relationship. In my domains, individuals could have multiple preferences (one-to-many). Regards Jeff Boyce Microsoft Office/Access MVP > Jeff > [quoted text clipped - 29 lines] >> > >> > Martin Ok, thanks Jeff - I have changed the relationships to 1-many in the SQL query window - seems to work now (although I struggle with understanding relationships!) - Thanks for your help. > I'm not sure why only the first one would show, but the SQL statement > includes an Inner Join. If there are no "matching" records in the [quoted text clipped - 42 lines] > >> > > >> > Martin To get the best use of Access' features and functions, it would be worth your while to spend a bit of time brushing up on "relationships" ... they are pretty much at the heart of a relational database like Access! Good luck! Regards Jeff Boyce Microsoft Office/Access MVP > Ok, thanks Jeff - I have changed the relationships to 1-many in the SQL > query window - seems to work now (although I struggle with understanding [quoted text clipped - 51 lines] >> >> > >> >> > Martin |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.