digdoug:

The error message is complaining about a foreign key constraint, so you might want to check your table definition to find out what column(s) could be the problem. For example, if the reservationid column is FKed to another table, that other table will need the record for this reservationid to be inserted before you can insert this one.

...roboticus