Continuous subform per continuous form element

C

capkrugers

I am trying to make a form which has two continuous combo boxes, one
for each of two independent fields, and a continuous set of two more
combo boxes to the right of these two. That is, for every unique
primary key ("appointmentID") in the database, there will be multiple
values on top of multiple values: each "appointmentID" will have
several relatives, each of which have a relationship type and bloodline
in the left set of combo boxes mentioned above. For each relative,
though, there is a set of continuous combo boxes so that each relative
is capable of having multiple diseases each with an age associated with
first onset and a disease type.

I wish to avoid having multiple listings of the relative's relationship
and bloodline, meaning there should be vertical gaps between entries
for the relatives. Since I cannot use a nested continuous form inside a
continuous form, is there any way I can work around this, or is this
kind of design pretty much impossible in Access?
 
Top