Portals, Table Occurrences and so on

Dear Newsgroup,

I am dealing with a problem in order to fine tuning the presentation
of information in my clinical DB (FM 8.5 adv. XP).

I have some table all related to the demographics (patient names,
age...) through an internal ID.
Everything works fine. Now I would like to improve the DB so that
starting from the first layout (demographics) anyone can see how many
exams (imaging, blood samples) were done and when.
I thought to use portals to do that and I was in facts able to get a
summary of all the imaging exams done by the single patient pretty
easily.
I would like to go further and have a summary area in the layout
reporting all the exams, blood samples etc... the patient did after
the admission. I could create many portals (one for each table) and
put them together to get the information I need, but is there a more
elegant/efficient way ?

Here we come to the Table occurences issue: although I read something
about that, still I do not know exactly what they are and what they
are for..
Finally, changing the relationships so that the tables would be
related each other and not simply to the demographics, would it
help ?

I am sorry, I understand I was not clear at all, please ask me and I
will do my best to be as more precise I can.

Thank you for any idea

Diego

.

Relevant Pages

  • Re: Locked out of fields in Access 2000
    ... A free tutorial written by Crystal (MS Access MVP): ... with each exam performed on the patient with their 20 variables, ... exams being performed. ... Dirk Goldgar, MS Access MVP ...
    (microsoft.public.access.forms)
  • Re: IC question
    ... for the time you are on site, plus fee per patient. ... problem because we have so many patients waiting for their exams. ... accommodating and flexible I try to be with my schedule. ... If we schedule a stress echo and the patient doesn't show, ...
    (sci.med.transcription)
  • Re: Problem with Nested table
    ... However, since each visit is unique to each patient, there was never more ... query which joins the visits with the appropriate demographics, ... I have a problem during the application of a Decision Tree. ...
    (microsoft.public.sqlserver.datamining)
  • Problem with Nested table
    ... How can I add this calculated column into my table in the DSV? ... uniquely identifies a patient visit. ... query which joins the visits with the appropriate demographics, ... I have a problem during the application of a Decision Tree. ...
    (microsoft.public.sqlserver.datamining)
  • Re: Creating database and wish to automate
    ... I would like to look patient up by last name to complet the hospitaization ... you should NOT store the name or other demographics redundantly ... The Combo Box can also display the patient's ... combo's row source query. ...
    (microsoft.public.access.tablesdbdesign)