you could create an updatable view for this or even easier
a stored procedure.

--

See you at the First European Firebird Conference in May in Fulda, Germany
Early Registration Fee only valid until Apr 15th -
http://www.firebird-conference.com

IBExpert - The most Expert for InterBase and Firebird --- www.ibexpert.com
HK Software - Holger Klemt - Huntestrasse 15 - D-26135 Oldenburg
Telefon Telefax +49 700 IBEXPERT (42397378) www.h-k.de
Schulungen - Projektunterst�tzung - Delphi - InterBase - AS/400