So basically I have two tables
Table 1 - groups
Table 2 - members
And in phpmyadmin it all works good when I try to input data, but I run into errors whenever I try to add new data into second table through my Clarion app. Whenever I try to insert data I get the following message:
Attemtps to automatically number this record have failed. File: members Key: mem:PK_member_ID Error: Cannot add or update a child row: a foreign key constraint fails ('dbusername','members',CONSTRAINT 'FK_group_ID' FOREIGN KEY('group_ID')REFRENCES 'groups'('group_ID') ON UPDATE CASCADE)(S1000).
I’ve tried everything I could think of only way I managed to work around it is by removing the auto increment but that kinda defeats the whole purpose of the ID so doesen’t really work for me.