History & Subdatasheets

[dkw614]

Hello!

I need some expert advice on adding a subdatasheet (or perhaps a better
solution) to my database.

I am developing a medical patient database, and I need to be able to see the
history of past drug treatments while simultaneously viewing the "current
patient summary" data.

I was thinking that the best way to do this would be to create a "Patient
Summary" form from which the data retrieved would be generated by the end
result of a query using a date range; and then adding a subdatasheet to the
bottom of the form which would show all of the past drug treatments,
chronologically.

Would this work? Is it even possible? What is the best way to arrive to my
desired end result? Any help you could offer would be greatly appreciated.

Thank you!

 

[Haris Rashid]

hi,

you might want to try the software product at http://www.medic-systems.com
that accomplishes the same.

Regards,

 

[John Vinson]

Hello!

I need some expert advice on adding a subdatasheet (or perhaps a better
solution) to my database.

There MUST be a better solution. Datasheets, and especially
subdatasheets, are of very limited value.

I am developing a medical patient database, and I need to be able to see the
history of past drug treatments while simultaneously viewing the "current
patient summary" data.

A Form with a Subform would work just fine. It is not necessary to
have a subdatasheet in table design view to accomplish this. Of
course, you must have separate Tables of patient data and of past drug
treatments; you could base the Subform on a query of the latter,
sorted by date; you would use the PatientID as the master/child link
field.


John W. Vinson[MVP]