C
Chris
Hello everybody,
I'm programming a patient database, and one of the users
wants to collect additional patient data that only concerns
her patient category.
My current setup is a general table, linked to the specific
table in a one-to-one relationship with referential
integrity. I combined the two using a query and am now
basing a form on it. In a addition, the general table is
linked to all patient admissions using the same index.
However, when I now enter data into the form I get all
sorts of "this record canot be modified because a related
record is required in the table xxx." I also have found
that I cannot make a relationship with referential
integrity between the query and the subordinate table.
What is the best way to get around this, if any. Thanks for
any advice
Chris
I'm programming a patient database, and one of the users
wants to collect additional patient data that only concerns
her patient category.
My current setup is a general table, linked to the specific
table in a one-to-one relationship with referential
integrity. I combined the two using a query and am now
basing a form on it. In a addition, the general table is
linked to all patient admissions using the same index.
However, when I now enter data into the form I get all
sorts of "this record canot be modified because a related
record is required in the table xxx." I also have found
that I cannot make a relationship with referential
integrity between the query and the subordinate table.
What is the best way to get around this, if any. Thanks for
any advice
Chris