Multiple tables on to one form

[LMB]

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

 

[tina]

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]

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]

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]

Thanks, Tina....I am definitely in the "flat file" mode. <g> Thanks for
trying!

Linda