Unable to add a branch
Not able to add a branch to the customer, tried with existing debtorno present in debtorsmaster table as well as with non-existing..
getting below error:
Database Error 1452 : The branch record could not be inserted or updated because
Cannot add or update a child row: a foreign key constraint fails (`weberpdemo`.`custbranch`, CONSTRAINT `custbranch_ibfk_1` FOREIGN KEY (`debtorno`) REFERENCES `debtorsmaster` (`debtorno`))
Database SQL Failure : The SQL that failed was
INSERT INTO custbranch (branchcode, debtorno, brname, braddress1, braddress2, braddress3, braddress4, braddress5, braddress6, lat, lng, specialinstructions, estdeliverydays, fwddate, salesman, phoneno, faxno, contactname, area, email, taxgroupid, defaultlocation, brpostaddr1, brpostaddr2, brpostaddr3, brpostaddr4, brpostaddr5, disabletrans, defaultshipvia, custbranchcode, deliverblind) VALUES ('AP', 'ANGRY1', 'Angus Rouledge - Florida', '1821 Sunnyside', 'Ft Lauderdale', 'Florida', 'Florida', '42554', 'United States', '0', '0', '', '0', '0', 'ERI', '', '', '1234567890', 'FL', '', '1', 'FL', '', '', '', '', '', '0', '1', '', '1')
|