Foreign Keys

[LucidNonsense]

Hi there I'm setting up twp table that are linked with a foreign key.

members

customer_id (primary)
fobnumber ZERO FILLED
firstname
lastname
emailaddress
access_id (foreign)

userAccess

access_id (primary)
username
password

(engine: InnoDB)
I have created recreated these tables, when both tables seem to linked. Data will go in to one database but not the other. i get the following error:

#1452 - Cannot add or update a child row: a foreign key constraint fails

please help

Craig.

[gerard4143]

Check this web site out

http://www.databasejournal.com/features/mysql/article.php/2248101

[pritaeas]

It means that you are trying to update a foreign access_id, which is not yet in the userAccess table.