November 19th, 2008, 02:31 PM
posted to microsoft.public.access.tablesdbdesign
|
|
|
Serial one-to-many tables
Thanks Roger. I will check it out.
"Roger Carlson" wrote:
On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "SubForm3Levels.mdb" which illustrates how to do this. You
can find it he
http://www.rogersaccesslibrary.com/f...ts.asp?TID=263
Interestingly, I used a medical paradigm for this sample too.
Visits --- Procedures --- Complications --- Interventions
--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/...UBED1=ACCESS-L
"CuriousMark" wrote in message
...
I need help with design of a database I am writing to keep track of
procedures that I do on patients. For each patient, one or more procedures
can be done. For each procedure, one or more locations can be sampled (I
want
to keep track of the sequence of locations sampled, i.e. 1, loc2R; 2,
loc2L;
3, loc7; etc). For each location, one or more samples (pass1, pass2,
pass3,
etc.) can be taken. For each sample there is a result (pos, neg,
non-diagnostic).
I've come up with this series of tables:
tblNames
NameID
LastName
FirstName
tblProcedure
ProcedureID
NameID
ProcedureDate
ProcedureType
tblLocation
LocationID
ProcedureID
LocationSequence
LocationName
tblResult
ResultID
LocationID
PassNumber
PassResult
I keep getting lost trying to create a form or sequence of forms that will
enable me to enter all the data. It seems that I need a subform
(Location:Result) inside a subform (ProceduLocation) inside another
subform (Name:Procedure). On the highest level form (Name) I want to be
able
to select from the existing names (shown as LastName & ", " & FirstName)
or
enter a new name. Any help with fixing my database design would be much
appreciated. Thanks.
|