[RESOLVED] Error 1005 when trying to save Intermediate table

[dmacman1962]

Hi All,

I am beginning to use PK's and FK's and an intermediate table and I am stuck on this error:

1005 - Can't create table 'ftc_normalized_local.#sql-fdc_24' (errno: 15)

I am trying to setup an intermediate table to store the grade levels from one table, with the form that uses them in another table. (I can get the first FK to save, but its the second one giving the error).

I attached a snapshot of the 3 tables, and the foriegn key of the intermediate table.
tables image

I appreciate the help and guidance,
Don

[dmacman1962]

Well, I resolved this.

After trying and checking over and over, I opened the form table, and there were 2 records, and one of them had a zero value for the formtype table. When I deleted the 2 records, and added the FK, it worked fine.

FYI to anyone with a similar issue.

Dmacman