A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Serial one-to-many tables



 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old November 16th, 2008, 04:57 PM posted to microsoft.public.access.tablesdbdesign
CuriousMark
external usenet poster
 
Posts: 61
Default Serial one-to-many tables

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.
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:12 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.