C
Chris
Hello everybody,
I've been staring at this problem for six hours straight
now without making any headway, so ANY clue as to what
might be causing this is immensely appreciated.
I have two tables, Patients and Admissions, which are
linked in a 1 <-> Many relationship with referential
integrity. I also have a corresponding form and respective
subform where the link master and child fields are set to
the single unique identifier.
The problem now is that when I go to a new record on the
master form (either using DoCmd.GoToRecord , , acNewRecord
or record navigation buttons) and try to enter the primary
key, I get the error message "You cannot add or change a
record because a related record is required in table
'Admissions'".
This error did not appear when i started making the
database; it only started appearing recently, on and off,
and now it seems to be there permannetly.
Once again, any idea as to what might be the cause of thsi
is greatly appreciated. Thanks in advance.
Chris
I've been staring at this problem for six hours straight
now without making any headway, so ANY clue as to what
might be causing this is immensely appreciated.
I have two tables, Patients and Admissions, which are
linked in a 1 <-> Many relationship with referential
integrity. I also have a corresponding form and respective
subform where the link master and child fields are set to
the single unique identifier.
The problem now is that when I go to a new record on the
master form (either using DoCmd.GoToRecord , , acNewRecord
or record navigation buttons) and try to enter the primary
key, I get the error message "You cannot add or change a
record because a related record is required in table
'Admissions'".
This error did not appear when i started making the
database; it only started appearing recently, on and off,
and now it seems to be there permannetly.
Once again, any idea as to what might be the cause of thsi
is greatly appreciated. Thanks in advance.
Chris