Helen,

> 2. I set your Keylinks to ID. (Notice that I had a little trouble with this because you made this a char(12) so your unique id values get stored as "FIRST ", "SECOND " and "THIRD " and a query 'where "ID" = 'FIRST' will not find the row...

According to the SQL standard and how IB implements it, it surely
should.
Not that I am suggesting to use CHAR fields as primary keys anyway, just
they are no less ideal than VARCHARs.
Ciao
--
____
_/\/ando