Creating a continious sub form
in [Form]
|
From: John on 7 Jan 2010 16:52 I have created three sub forms in a main form all filling different tables. They all have the same primary key of medical record number. First question how can I have the medical record number filled in for all fileds labeled medical record number after only filling it in on one field? Second question, I was told I could make the sub forms continious so I can always see the data that was input previously. I can find plenty of help in placing sub forms but no help in what continious forms do for me as well as how to take an existing form and make it continious. Thanks
From: Al Campagna on 7 Jan 2010 18:09 John, Not sure what you mean by... > how can I have the medical record number filled in for all fileds labeled > medical record number after only filling it in on one field? I think you may not realize the power of a relational database, and the concept of table relationships. Let me use an example such as ONE Patient, to MANY office visits... Given a parent table, like tblPatient, and a child table, like tblVisits, related to each other by PatientID... Your main form, frmPatient, (a single form) will be based on tblPatients. Your subform, frmVisits, on that form (a continous form) will be based on tblVisits. The subform will be related to the main form through the subform's properties of... Link Child Field = PatientID and Link Parent Field = PatientID When viewing John Smith's main form, and new visits added to the frmVisits subform will be forced to have the same PatientID "automagically" because of the relationship between the tables. You don't have to worry about that ascpect. Ex. Single Main (The ONE) Name Address City State John Smith 67 Main St Boston MA ----------- Ex. Continuous Subform (The MANY) Date From To Desc 1/1/09 10:00am 11:00am Flu Shot 1/10/09 1:00pm 1:30pm Checkup 2/7/09 11:00am 11:45am Blood Test etc... etc... **A single form can be changed to a continous form by setting the form's Default View property from Single Form to Continuous Form. -- hth Al Campagna Microsoft Access MVP 2006-2009 http://home.comcast.net/~cccsolutions/index.html "Find a job that you love... and you'll never work a day in your life." "John" <John(a)discussions.microsoft.com> wrote in message news:BD3B2744-9B71-4C84-8425-EA1C4A9A3CD7(a)microsoft.com... >I have created three sub forms in a main form all filling different tables. > They all have the same primary key of medical record number. First > question > how can I have the medical record number filled in for all fileds labeled > medical record number after only filling it in on one field? > Second question, I was told I could make the sub forms continious so I can > always see the data that was input previously. I can find plenty of help > in > placing sub forms but no help in what continious forms do for me as well > as > how to take an existing form and make it continious. > Thanks
From: John W. Vinson on 8 Jan 2010 00:29 On Thu, 7 Jan 2010 13:52:01 -0800, John <John(a)discussions.microsoft.com> wrote: >I have created three sub forms in a main form all filling different tables. >They all have the same primary key of medical record number. First question >how can I have the medical record number filled in for all fileds labeled >medical record number after only filling it in on one field? No, you cannot; not if it is the Primary Key of the table. A primary key is, by definition, unique within that table. The medical record number must be a NON-unique foreign key field in the related table. Each table should have its own primary key (distinct from the medical record number). You can use the Medical Record Number as the master and child link field property of each subform, and it will be automatically filled in when you create new records. >Second question, I was told I could make the sub forms continious so I can >always see the data that was input previously. I can find plenty of help in >placing sub forms but no help in what continious forms do for me as well as >how to take an existing form and make it continious. >Thanks A continuous form lets you see multiple records at the same moment on screen. You can make an existing Single form into a Continuous one by opening it in design view and changing the "Default View" property from "Single" to "Continuous". To be most useful, you should move all the controls up to the top of the detail section, and snug the bottom of the detail section up to the bottom of the controls, so the repeated block of controls will fit on the screen. -- John W. Vinson [MVP]
|
Pages: 1 Prev: Saving an access form Next: Using Form to input multiple field to table at once |