K
Kevin
I get an error 3201 "cannot add a record because a related record is required
in table..."
It involves the relationship between 2 tables: tblItem & tblItemDetail
4 like fields are primary keys in tblItem: ProjectName, BidNumber,
RoomNumber, ItemNumber
This creates one-to-many relationship with tblItemDetail. I can enter a
record directly into a subdatasheet (tblItemDetail) of tblItem without fail,
but I created a query because of some calculated field requirements, and when
I try to enter a new record, I get the error message.
I inserted a subdatasheet to see what was happening and unhid all columns.
I found that when I add a new record, only 3 of the 4 related fields
automatically duplicate the "parent" field's record. The field "RoomNumber"
does not. It seems like I have the relationships set correctly, because it
all appears the same. I have checked the field properties to make sure they
match, the join properties in the query, and also the relationship properties
of the database iteself.
What can I look for that might be causing the relationship to fail? Any
suggestions of what I should look for is appreciated!
in table..."
It involves the relationship between 2 tables: tblItem & tblItemDetail
4 like fields are primary keys in tblItem: ProjectName, BidNumber,
RoomNumber, ItemNumber
This creates one-to-many relationship with tblItemDetail. I can enter a
record directly into a subdatasheet (tblItemDetail) of tblItem without fail,
but I created a query because of some calculated field requirements, and when
I try to enter a new record, I get the error message.
I inserted a subdatasheet to see what was happening and unhid all columns.
I found that when I add a new record, only 3 of the 4 related fields
automatically duplicate the "parent" field's record. The field "RoomNumber"
does not. It seems like I have the relationships set correctly, because it
all appears the same. I have checked the field properties to make sure they
match, the join properties in the query, and also the relationship properties
of the database iteself.
What can I look for that might be causing the relationship to fail? Any
suggestions of what I should look for is appreciated!