Database for research site

M

malagol13

Hi All

Im creating a database for research patients where I want to create a table
with Ethics information that will allow me to keep track of documents
approved and documents yet to be approved; since I dont know how many
documents I can expect to be added (it could be just 1 but it could also be
30), im not sure how many new fields to add in my table, I know I can do
something with relationships but im really not sure how to go about this, any
ideas/suggestions?
Ta
 
K

KARL DEWEY

Adding a fiekd for every document is WRONG.
Maybe two tables like these --
tblDocument --
DocID - Autonumber - primary key
DocNumber - text
DocTitle - text
DraftDate - DateTime
Drafter - text
Final - DateTime
Revision - text - Last revision letter
RevDate - DateTime - Last revision

tblDocActivity --
ActuvityID - Autonumber - primary key
DocID - number - long inteher - foreign key
ActStartDate - - DateTime
ActPerson -
ActType
ActEndDate - DateTime
ActPassTo -
ActCmts - memo

use form/subform to add/update actions.
 
J

John W. Vinson

Hi All

Im creating a database for research patients where I want to create a table
with Ethics information that will allow me to keep track of documents
approved and documents yet to be approved; since I dont know how many
documents I can expect to be added (it could be just 1 but it could also be
30), im not sure how many new fields to add in my table, I know I can do
something with relationships but im really not sure how to go about this, any
ideas/suggestions?
Ta

"Fields are expensive. Records are cheap."

Tables should grow down - adding new records - not across - adding new fields!

If each Patient may have an arbitrary number of Documents you need two tables
in a one to many relationship: Patients, with a PatientNumber and biographical
information; related one to many to a table of Documents, with a patientnumber
as a link, a document date, approval status, title of the document, etc. If
one patient has three documents there will be three records in Documents for
that patient; if another has 73, there will be 73 rows.

You might want to check out some of the tutorials here:

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

Roger Carlson's tutorials, samples and tips:
http://www.rogersaccesslibrary.com/

A free tutorial written by Crystal:
http://allenbrowne.com/casu-22.html

A video how-to series by Crystal:
http://www.YouTube.com/user/LearnAccessByCrystal

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials
 
J

John W. Vinson

Hi All

Im creating a database for research patients where I want to create a table
with Ethics information that will allow me to keep track of documents
approved and documents yet to be approved; since I dont know how many
documents I can expect to be added (it could be just 1 but it could also be
30), im not sure how many new fields to add in my table, I know I can do
something with relationships but im really not sure how to go about this, any
ideas/suggestions?
Ta

Do note that any database containing personally identifiable patient data and
medical records is subject to the very stringent HIPAA patient-privacy
regulations. You should talk to your research organization about their
requirements for data control and privacy.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top