I have had an large database in IB running for several years.

I have just installed Firtebird and Delphi 2005.

When I connect a BDP I get a message saying there is an ambiguous
field between contraints and relations tables. I have not had any
problems in the past.

My tables are foreign keyed but have the same field names for the
foreign keys between tables. The tables also have a primary key.

Is the similarity of names a problem? Should EVERY field in different
tables be uniquely named? For example, instead of "ForeignKey1" in
each of several tables, should I have "Table1ForeignKey1"
and "Table2ForeignKey1".

Do I need to write a new database?