Table Design / Form design - How to manage vertical structures

  • Thread starter Thread starter Qhalis
  • Start date Start date
Q

Qhalis

All,

I am new to Access and trying to write an application to record
details of different types of medical examinations.

I did some data analysis work and came up with a normalized model for
the data, got some UI style requests from the users and then tried to
implement it with Access.

I hit some problems was hoping that someone might know of a built in
(or any other) way of nicely solving this problem in Access

Problem Description:

I have a set of examinations and a set of symptoms to be checked for
each.
In a given exam we do not fill in something for each symptom (say,
they may not be having headaches) but I must offer the user a place in
which to fill in all the possible symptoms for that exam type.


It is possible to have a sub-form and ask them to add each symptom as
they go

i.e.
Subform starts blank.
They add Headache and fill in some details,
they add Toothache and fill in the details,
they add whatever and fill in the details and then save


but I was hoping to have a situation where all the possible symptoms
to be checked are shown on the screen at the start, they can fill in
the details on the ones applicable and then press save, which only
saves the filled in ones.


i.e
Subform starts with Headache,
Toothache,
Whatever,
Whatever else

They fill in the details on H,T,W and when they press save these
three are
saved but the WE is ignored.


Now I can think of possible ways to do this that involve lots of
coding but I wanted to check if there was a simple way of doing it
before I tried the complicated ways.


Any aid would be appreciated,
Thanks in advance,
Q.
 
I have done this in my databases, and it does involve some coding but not
too much.

I have one database where I always want information on each item in the
subform. In this case I just have some code to produce all the necessary
records in the underlying table before the form is displayed.

In another case I want to do the same as you are trying to achieve, and use
a temporary table for this - ie the temporary table is created before the
form is displayed, and then an append query adds records to the main table
when the user clicks the OK button - this is done with a query that only
selects non null records.
 
Back
Top