forms and subforms

[jen]

Hello, I have a situation that I will try to explain the
best way possible. I have four tables. Table1 has
personal information, table2 has information that will be
input as order requests are received, table 3 has a list
of annotations that will be added to each order that is
made, and table 4 is a lookup table for each of the
possible annotations that can be used. Personal
information has already been put into the system and now I
want to create a form that will allow input of information
into table2 and table3. The relationships defined between
the tables are as follows:

Table1 --> table2 by personal id
Table1 --> table3 by personal Id
Table3 --> table4 by annotation id

This is how I was instructed to relate the tables because
I am following certain rules for creating this database.
Table 2 and table 3 also have unique identifiers.

I tried creating a form (table 1 fields) and a subform (
table2 fields) and another subform within that subform
(table 3 fields). The problem is that the annotations in
the last subform are recognized only for the person and
not the particular order. So my final report is showing
the annotations for the person and not for the particular
order. Is there any way that I can still follow the
relationships defined but be able to enter the annotations
for the particular order? Should I create some field on
the form that will read the annotation entered but store
it in a field in table2 that way it will be for a
particular submission? How would I go about doing that?

Sorry for the long question.

Thank you!!

 

[Gerald Stanley]

Not without a relationship defined between Table2 and
Table3. Unless the unique identifier for table2 appears on
table3 as a foreign key, you will never know which
annotations have been input against which order.

Hope That Helps

Gerald Stanley MCSD