> Pavel, that works!
>
> I see what I was doing wrong. I thought the foreign key constraint
> should be defined from the master table not the child table.
>
> I put the constraint on the basket table and it works.
>
> This is different to what I am used to with Advantage Database server.
>
> Martijn,
>
> Sorry, I didn't understand what you meant.

No worries - because of you were trying to do, I thought I didn't
fully understand the problem and didn't have all information :-)
That why I asked for more ... *g*

Good luck with your project.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server
Upscene Productions
http://www.upscene.com