If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Multiple tables on to one form
Hi,
This is my first time making a database with multiple tables. I am wondering how to get all the fields on these tables to one form. Here is the information about my database. I posted about this database before on 5/1 and this is how I set up my tables. If I didn't set the tables up right, let me know. I am trying to do a "real" database instead of a flat one. I think I set up my relationships right but if someone could tell me what they would do, that would be great. I don't know how to write code so I use the design views to make my queries, forms and reports. The purpose is to keep track of total unnecessary breathing treatments ordered. A Therapist will do chart audits and compare what the total number of aerosol treatments a doctor has ordered for a 24-hour period with what would have been ordered if protocols were followed. When we add up all the unnecessary treatments we will then determine how many extra therapists were needed (FTE's Full Time Equivalents) to do these "unnecessary treatments". Thus showing that Ordering protocols saves the hospital money. I will want a monthly, quarterly and yearly report for each of the 3 facilities. I would also like to have a report that shows each physician and how many extra treatments are ordered by month/ quarter and year. We are just tracking daily totals. Not admission days or if patients are re-admitted. The database is on a Private Network drive using Novel so I think it is secure enough to put patient MR and Admission numbers there but I will be checking with the IS department on Monday to make sure. lutblTherapist numTherapistID-Auto Number strRtLastName strRtFirstName lutblPhysID strPhysID-System ID strPhysLName strPhysFName strPhysSpecialty lutblSpecialty strSpecialty lutblFacility strFacility tblPatientInformation *numPtID-Auto Number strPtAdmitNum strPtMRNumber strPtLastName strPtFirstName strAdmitDx strRespDx strRespDx strFacility tblAudits *numAuditID-Auto Number numTherapistID numAuditTxs numPtID tblTreatmentsOrderd *numTxsOrderdID-Auto Number strPhysID numPtID strFacility dttTxsOrderDate numTxsOrdered tblPhysicians *strPhysID-Number assigned by Hospital System strPhysLName strPhysFName strSpecialty Thanks, Linda |
#2
|
|||
|
|||
Multiple tables on to one form
why do you want to show all the fields of all the tables on one form? it
could be done, using a tab control and subforms, but you'd have to do a fair amount of programming (at least) to make it useful in any sort of practical way - including managing the subform "loading", or the form would take longer and longer to load, as more data was added to the tables. if you'll post your reasons for wanting a single-form setup, maybe some folks will reply with suggestions for alternate set-ups that will meet your needs. btw, if more than one person will be using the database, you should use a frontend/backend (FE/BE) setup. if you've never done that, there've been a lot of posts about the subject recently that you can search for. hth "LMB" wrote in message ... Hi, This is my first time making a database with multiple tables. I am wondering how to get all the fields on these tables to one form. Here is the information about my database. I posted about this database before on 5/1 and this is how I set up my tables. If I didn't set the tables up right, let me know. I am trying to do a "real" database instead of a flat one. I think I set up my relationships right but if someone could tell me what they would do, that would be great. I don't know how to write code so I use the design views to make my queries, forms and reports. The purpose is to keep track of total unnecessary breathing treatments ordered. A Therapist will do chart audits and compare what the total number of aerosol treatments a doctor has ordered for a 24-hour period with what would have been ordered if protocols were followed. When we add up all the unnecessary treatments we will then determine how many extra therapists were needed (FTE's Full Time Equivalents) to do these "unnecessary treatments". Thus showing that Ordering protocols saves the hospital money. I will want a monthly, quarterly and yearly report for each of the 3 facilities. I would also like to have a report that shows each physician and how many extra treatments are ordered by month/ quarter and year. We are just tracking daily totals. Not admission days or if patients are re-admitted. The database is on a Private Network drive using Novel so I think it is secure enough to put patient MR and Admission numbers there but I will be checking with the IS department on Monday to make sure. lutblTherapist numTherapistID-Auto Number strRtLastName strRtFirstName lutblPhysID strPhysID-System ID strPhysLName strPhysFName strPhysSpecialty lutblSpecialty strSpecialty lutblFacility strFacility tblPatientInformation *numPtID-Auto Number strPtAdmitNum strPtMRNumber strPtLastName strPtFirstName strAdmitDx strRespDx strRespDx strFacility tblAudits *numAuditID-Auto Number numTherapistID numAuditTxs numPtID tblTreatmentsOrderd *numTxsOrderdID-Auto Number strPhysID numPtID strFacility dttTxsOrderDate numTxsOrdered tblPhysicians *strPhysID-Number assigned by Hospital System strPhysLName strPhysFName strSpecialty Thanks, Linda |
#3
|
|||
|
|||
Multiple tables on to one form
Hi Tina,
I want all the fields to be on one page is all. I have used subforms before but I have had trouble getting the tab stops to continue from the main form to the subforms. I guess the main reason is that I use the Form Wizard to set up my main form and if I have all the fields in a query, it's all set up in one swoop. The front end an back end would be difficult to execute because the users would have a lot of trouble saving the front end to their Home drive. Most of the databases I set up are only used for a few months or so to get some questions answered then once that's done, the database isn't used anymore. Flat databases have worked well for our purposes but I want to learn how to "normalize" the tables. I did make a FE and BE once and there were so many problems compared to having the whole database on the network drive. Basically because the users don't understand the file structure....If I ask them where they saved a document they lost, they say they saved it in word or I saved it to windows. We have been using one database I made a few years ago and have had no problems so far. Is there a way to make it so only one user at a time can open the database so there aren't file corruptions or are corruptions on multi-user databases caused due to some other reason? Thanks, Linda "tina" wrote in message ... why do you want to show all the fields of all the tables on one form? it could be done, using a tab control and subforms, but you'd have to do a fair amount of programming (at least) to make it useful in any sort of practical way - including managing the subform "loading", or the form would take longer and longer to load, as more data was added to the tables. if you'll post your reasons for wanting a single-form setup, maybe some folks will reply with suggestions for alternate set-ups that will meet your needs. btw, if more than one person will be using the database, you should use a frontend/backend (FE/BE) setup. if you've never done that, there've been a lot of posts about the subject recently that you can search for. hth "LMB" wrote in message ... Hi, This is my first time making a database with multiple tables. I am wondering how to get all the fields on these tables to one form. Here is the information about my database. I posted about this database before on 5/1 and this is how I set up my tables. If I didn't set the tables up right, let me know. I am trying to do a "real" database instead of a flat one. I think I set up my relationships right but if someone could tell me what they would do, that would be great. I don't know how to write code so I use the design views to make my queries, forms and reports. The purpose is to keep track of total unnecessary breathing treatments ordered. A Therapist will do chart audits and compare what the total number of aerosol treatments a doctor has ordered for a 24-hour period with what would have been ordered if protocols were followed. When we add up all the unnecessary treatments we will then determine how many extra therapists were needed (FTE's Full Time Equivalents) to do these "unnecessary treatments". Thus showing that Ordering protocols saves the hospital money. I will want a monthly, quarterly and yearly report for each of the 3 facilities. I would also like to have a report that shows each physician and how many extra treatments are ordered by month/ quarter and year. We are just tracking daily totals. Not admission days or if patients are re-admitted. The database is on a Private Network drive using Novel so I think it is secure enough to put patient MR and Admission numbers there but I will be checking with the IS department on Monday to make sure. lutblTherapist numTherapistID-Auto Number strRtLastName strRtFirstName lutblPhysID strPhysID-System ID strPhysLName strPhysFName strPhysSpecialty lutblSpecialty strSpecialty lutblFacility strFacility tblPatientInformation *numPtID-Auto Number strPtAdmitNum strPtMRNumber strPtLastName strPtFirstName strAdmitDx strRespDx strRespDx strFacility tblAudits *numAuditID-Auto Number numTherapistID numAuditTxs numPtID tblTreatmentsOrderd *numTxsOrderdID-Auto Number strPhysID numPtID strFacility dttTxsOrderDate numTxsOrdered tblPhysicians *strPhysID-Number assigned by Hospital System strPhysLName strPhysFName strSpecialty Thanks, Linda |
#4
|
|||
|
|||
NOT SOLVED - Multiple tables on to one form
i think you're still in a "flat-file" mode of thinking, and i'm not sure how
to advise you. this is a fairly new post, so i put the "not solved" in the header hoping that others will see and contribute to the thread. if you don't get additional responses after a day or two, suggest you repost. remember it's the weekend, some of the best minds in the newgroup may not be looking at posts frequently, or until Monday. good luck. "LMB" wrote in message ... Hi Tina, I want all the fields to be on one page is all. I have used subforms before but I have had trouble getting the tab stops to continue from the main form to the subforms. I guess the main reason is that I use the Form Wizard to set up my main form and if I have all the fields in a query, it's all set up in one swoop. The front end an back end would be difficult to execute because the users would have a lot of trouble saving the front end to their Home drive. Most of the databases I set up are only used for a few months or so to get some questions answered then once that's done, the database isn't used anymore. Flat databases have worked well for our purposes but I want to learn how to "normalize" the tables. I did make a FE and BE once and there were so many problems compared to having the whole database on the network drive. Basically because the users don't understand the file structure....If I ask them where they saved a document they lost, they say they saved it in word or I saved it to windows. We have been using one database I made a few years ago and have had no problems so far. Is there a way to make it so only one user at a time can open the database so there aren't file corruptions or are corruptions on multi-user databases caused due to some other reason? Thanks, Linda "tina" wrote in message ... why do you want to show all the fields of all the tables on one form? it could be done, using a tab control and subforms, but you'd have to do a fair amount of programming (at least) to make it useful in any sort of practical way - including managing the subform "loading", or the form would take longer and longer to load, as more data was added to the tables. if you'll post your reasons for wanting a single-form setup, maybe some folks will reply with suggestions for alternate set-ups that will meet your needs. btw, if more than one person will be using the database, you should use a frontend/backend (FE/BE) setup. if you've never done that, there've been a lot of posts about the subject recently that you can search for. hth "LMB" wrote in message ... Hi, This is my first time making a database with multiple tables. I am wondering how to get all the fields on these tables to one form. Here is the information about my database. I posted about this database before on 5/1 and this is how I set up my tables. If I didn't set the tables up right, let me know. I am trying to do a "real" database instead of a flat one. I think I set up my relationships right but if someone could tell me what they would do, that would be great. I don't know how to write code so I use the design views to make my queries, forms and reports. The purpose is to keep track of total unnecessary breathing treatments ordered. A Therapist will do chart audits and compare what the total number of aerosol treatments a doctor has ordered for a 24-hour period with what would have been ordered if protocols were followed. When we add up all the unnecessary treatments we will then determine how many extra therapists were needed (FTE's Full Time Equivalents) to do these "unnecessary treatments". Thus showing that Ordering protocols saves the hospital money. I will want a monthly, quarterly and yearly report for each of the 3 facilities. I would also like to have a report that shows each physician and how many extra treatments are ordered by month/ quarter and year. We are just tracking daily totals. Not admission days or if patients are re-admitted. The database is on a Private Network drive using Novel so I think it is secure enough to put patient MR and Admission numbers there but I will be checking with the IS department on Monday to make sure. lutblTherapist numTherapistID-Auto Number strRtLastName strRtFirstName lutblPhysID strPhysID-System ID strPhysLName strPhysFName strPhysSpecialty lutblSpecialty strSpecialty lutblFacility strFacility tblPatientInformation *numPtID-Auto Number strPtAdmitNum strPtMRNumber strPtLastName strPtFirstName strAdmitDx strRespDx strRespDx strFacility tblAudits *numAuditID-Auto Number numTherapistID numAuditTxs numPtID tblTreatmentsOrderd *numTxsOrderdID-Auto Number strPhysID numPtID strFacility dttTxsOrderDate numTxsOrdered tblPhysicians *strPhysID-Number assigned by Hospital System strPhysLName strPhysFName strSpecialty Thanks, Linda |
#5
|
|||
|
|||
NOT SOLVED - Multiple tables on to one form
Thanks, Tina....I am definitely in the "flat file" mode. g Thanks for
trying! Linda "tina" wrote in message ... i think you're still in a "flat-file" mode of thinking, and i'm not sure how to advise you. this is a fairly new post, so i put the "not solved" in the header hoping that others will see and contribute to the thread. if you don't get additional responses after a day or two, suggest you repost. remember it's the weekend, some of the best minds in the newgroup may not be looking at posts frequently, or until Monday. good luck. "LMB" wrote in message ... Hi Tina, I want all the fields to be on one page is all. I have used subforms before but I have had trouble getting the tab stops to continue from the main form to the subforms. I guess the main reason is that I use the Form Wizard to set up my main form and if I have all the fields in a query, it's all set up in one swoop. The front end an back end would be difficult to execute because the users would have a lot of trouble saving the front end to their Home drive. Most of the databases I set up are only used for a few months or so to get some questions answered then once that's done, the database isn't used anymore. Flat databases have worked well for our purposes but I want to learn how to "normalize" the tables. I did make a FE and BE once and there were so many problems compared to having the whole database on the network drive. Basically because the users don't understand the file structure....If I ask them where they saved a document they lost, they say they saved it in word or I saved it to windows. We have been using one database I made a few years ago and have had no problems so far. Is there a way to make it so only one user at a time can open the database so there aren't file corruptions or are corruptions on multi-user databases caused due to some other reason? Thanks, Linda "tina" wrote in message ... why do you want to show all the fields of all the tables on one form? it could be done, using a tab control and subforms, but you'd have to do a fair amount of programming (at least) to make it useful in any sort of practical way - including managing the subform "loading", or the form would take longer and longer to load, as more data was added to the tables. if you'll post your reasons for wanting a single-form setup, maybe some folks will reply with suggestions for alternate set-ups that will meet your needs. btw, if more than one person will be using the database, you should use a frontend/backend (FE/BE) setup. if you've never done that, there've been a lot of posts about the subject recently that you can search for. hth "LMB" wrote in message ... Hi, This is my first time making a database with multiple tables. I am wondering how to get all the fields on these tables to one form. Here is the information about my database. I posted about this database before on 5/1 and this is how I set up my tables. If I didn't set the tables up right, let me know. I am trying to do a "real" database instead of a flat one. I think I set up my relationships right but if someone could tell me what they would do, that would be great. I don't know how to write code so I use the design views to make my queries, forms and reports. The purpose is to keep track of total unnecessary breathing treatments ordered. A Therapist will do chart audits and compare what the total number of aerosol treatments a doctor has ordered for a 24-hour period with what would have been ordered if protocols were followed. When we add up all the unnecessary treatments we will then determine how many extra therapists were needed (FTE's Full Time Equivalents) to do these "unnecessary treatments". Thus showing that Ordering protocols saves the hospital money. I will want a monthly, quarterly and yearly report for each of the 3 facilities. I would also like to have a report that shows each physician and how many extra treatments are ordered by month/ quarter and year. We are just tracking daily totals. Not admission days or if patients are re-admitted. The database is on a Private Network drive using Novel so I think it is secure enough to put patient MR and Admission numbers there but I will be checking with the IS department on Monday to make sure. lutblTherapist numTherapistID-Auto Number strRtLastName strRtFirstName lutblPhysID strPhysID-System ID strPhysLName strPhysFName strPhysSpecialty lutblSpecialty strSpecialty lutblFacility strFacility tblPatientInformation *numPtID-Auto Number strPtAdmitNum strPtMRNumber strPtLastName strPtFirstName strAdmitDx strRespDx strRespDx strFacility tblAudits *numAuditID-Auto Number numTherapistID numAuditTxs numPtID tblTreatmentsOrderd *numTxsOrderdID-Auto Number strPhysID numPtID strFacility dttTxsOrderDate numTxsOrdered tblPhysicians *strPhysID-Number assigned by Hospital System strPhysLName strPhysFName strSpecialty Thanks, Linda |
Thread Tools | |
Display Modes | |
|
|