Foreign Keys

•

What is DaniWeb IT Discussion Community?

You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 391,665 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,876 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our MySQL advertiser:

Thread Tools Display Modes

Views: 527 | Replies: 2

•

Join Date: Mar 2007

Posts: 2

Reputation: LucidNonsense is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

LucidNonsense LucidNonsense is offline

Offline

Newbie Poster

Foreign Keys

Feb 17th, 2008

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.