H
harmony
Hello,
I'm creating a database to track distribution of grants.
One table in particular captures information on the research being conducted
for which the grant was awarded.
To control the information entered several fields are connected to Look Up
tables that I created. As many as three fields are connected to the same Look
Up table. I created a one-to-many relationship between the matching fields in
the Look Up table and the Research Info table. The field in the Look Up table
has an unique index but is not the PK.
When I enter information into the Research table, it will not let me save it
because it says that my records do not match to the Look Up table, but the
record is selected from it!!!
What have I done? What can I do?
I'm creating a database to track distribution of grants.
One table in particular captures information on the research being conducted
for which the grant was awarded.
To control the information entered several fields are connected to Look Up
tables that I created. As many as three fields are connected to the same Look
Up table. I created a one-to-many relationship between the matching fields in
the Look Up table and the Research Info table. The field in the Look Up table
has an unique index but is not the PK.
When I enter information into the Research table, it will not let me save it
because it says that my records do not match to the Look Up table, but the
record is selected from it!!!
What have I done? What can I do?