Hi Christian,

> > Sure it does. If you define it as NULLable :-)
>
> > eg:
>
> > PERSON
> > --
> > Name
> > Last_Name
> > CarID
>
> > Where "car" is a FK to table CARS. CarID should be nullable.
>
> > CARS
> > --
> > CarID
> > Name
> > Brand
> > etc...
>
> > (obviously, this design is... well, sub-optimal, but it works)
>
> for me it is not only sub-optimal, but also unsatisfying, because
> all of my FKs are linked to the PKs of other tables which must never
> be NULL.
>
> Any other idea how I can do this?

Then I guess we don't understand... What are you
trying to say? Some relationsship where CHILD records
exists, but not PARENT records?

With regards,

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