However, data from Forms 1-7 all come from Q1-7 (or T1-7), Forms 8, 9, and 10 come from Q8-10, Form 9 comes from T9, etc.Įach table has a SubNUM field which could be primary key for each one, actually, because no subject will have two entries, but I really had problems with trying to do this with 1 to 1 relationships. That’s the problem with Access for me: I have so many questions and about 10 4-inch thick books, but I cannot find answers or examples that fit my needs. I kept getting the subform separated from the tab section of the form.Ī few forms have an actual 1-to-many relationship, as each subject may have multiple medications they are taking. I tried tabbed form pages, but I was not able to reference them very well –It would work if I could find more information. I have about 35 paper pages of data for each subject, some pages having 50 or more fill-in spots.
Skins football manager 2008 pro#
In the end, I will have to get this into as few separate tables as possible–they usually use Filemaker Pro and for them, one huge table would be OK. Hi, I have gigantic tables, up to the limit of query size, actually, and although there will not be a lot of records, there are an enormous number of fields required. Read today’s most popular VB problem-solving article. Hal McGee Engineering Data Manager Group Engineering – Process and Compliance Seating Products Group B/E Aerospace Winston-Salem, NC
Skins football manager 2008 full#
Instead of being a catalog of Access features, it is full of useful examples of Access databases covering all aspects of Access. However, one of the better Access books I have found is the Access Cookbook from O’Reilly. As far as the other issues, I cannot tell you what to do. Straight in my Have you set up the relationships in the relationships window? That should solve your foreign key problem. I know the part I teach and a very little VB, but I just can’t seem to get That foreign key value is not there already, I am having trouble. Going from Form7 (Q1-7 control course) to Form 8 (Q8-10 control source), if I have not had a problem with, say, Form 1 going to Form 2, because theyĪctually work from the same table/query (same control source), but when I am Problems with trying to do this with 1 to 1 relationships. Q1-7 (or T1-7), Forms 8, 9, and 10 come from Q8-10, Form 9 comes from T9,Įach table has a SubNUM field which could be primary key for each one,Īctually, because no subject will have two entries, but I really had However, data from Forms 1-7 all come from That’s the problem with Access for me: I have so many questions and aboutġ0 4-inch thick books, but I cannot find answers or examples that fit my Subform separated from the tab section of the form.Ī few forms have an actual 1-to-many relationship, as each subject may have Well –It would work if I could find more information. I tried tabbed form pages, but I was not able to reference them very I tried multi-page forms, but the 22-inch limit caught me.
I have about 35 paper pages of data for each subject, some pages having 50
Possible–they usually use Filemaker Pro and for them, one huge table would In the end, I will have to get this into as few separate tables as I have gigantic tables, up to the limit of query size, actually, andĪlthough there will not be a lot of records, there are an enormous number ofįields required.