linking a table to a query

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top