Hi All,
I am getting this error while adding new column record the table.
#1452 - Cannot add or update a child row: a foreign key constraint fails (`Appian`.`ISR_j_Product_TherapeuticArea`, CONSTRAINT `j_taProduct_fk` FOREIGN KEY (`therapeuticAreaId`) REFERENCES `ISR_TherapeuticArea` (`therapeuticAreaId`) ON DELETE NO ACTION ON UPDATE NO )
Could you please let me know how can we resolve this,
Discussion posts and replies are publicly visible
Is this on a Record or a Data Type?
I am getting this error in data base while adding new column into the table
Normally you would that type of message on an insert where the id in a column designated as a foreign key doesn't exist in the referenced table, not when you try to add a column to a record.