>Which is better ?
>Store all the procedure in the referentia intergrity or program it into forms ?
My personal preference is referential integrity code should be in stored procedures. That way, no matter how the data is accessed (e.g. any form in your application, outside ODBC source), that code will get fired and your data will not get corrupted.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao