I've got the same problem. If you notice, the article screenshot for a new recipe ("Figure 11 new recipe entry page") on page 2 also does not offer a way to select a category.

Presumably, the code generator is supposed to detect the contraint and display something in the UI??

Some notes:

MySQL version: 5.0.27.

I used the following script to generate the database:


drop table if exists recipes;
drop table if exists categories;
create table categories (
id int not null auto_increment,
name varchar(100) not null default '',
primary key(id)
) engine=InnoDB;


create table recipes (
id int not null auto_increment,
category_id int not null,
title varchar(100) not null default '',
description varchar(255) null,
date date null,
instructions text null,
constraint fk_recipes_categories foreign key (category_id) references
categories(id),
primary key(id)
) engine=InnoDB;