> I have a table called Item with keyfield itemno, and there are many
> tables use the itemno as foreign key, is there a generic way to check
> if a certain itemno already exists in one of related tables? Thanks.

No.

Martijn Tonies
Database Workbench - development tool for Firebird and more!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com