D
dsigano
Guest
I am getting the following error message on my database:
You cannot add or change a record because a related record is required in table 'MolTable'
I have a table called MolTable and a table called AssayTable. One MolTable record will be linked to several AssayTable records. However, one AssayTable record will be linked to exactly one MolTable record. I also have a main form for the MolTable data that contains a subform for AssayTable data. When I try to add a new record to the assay table, I get the above error message. There already are several AssayTable records for each MolTable record. I was simply trying to add an additional AssayTable record to an existing MolTable record. Compound ID is a field in both tables that links them together. CoumpoundID is not the key field in either table however. Any ideas?
Thanks!
Dina
You cannot add or change a record because a related record is required in table 'MolTable'
I have a table called MolTable and a table called AssayTable. One MolTable record will be linked to several AssayTable records. However, one AssayTable record will be linked to exactly one MolTable record. I also have a main form for the MolTable data that contains a subform for AssayTable data. When I try to add a new record to the assay table, I get the above error message. There already are several AssayTable records for each MolTable record. I was simply trying to add an additional AssayTable record to an existing MolTable record. Compound ID is a field in both tables that links them together. CoumpoundID is not the key field in either table however. Any ideas?
Thanks!
Dina