>Hi Dan,
>
>>If you have a trigger defined for a field in a database, the trigger will fire when the data has been modified. You would normally specify a stored procedure in your trigger and when the user modifies the field, the stored procedure is automatically executed.
>
>Defined for a field? I only thought it was possible to define one for a whole table. I'm not sure where you would define a field level trigger?
Sorry, it should have read "a field in a table that is in a database". You define a field level trigger in the table.
The table has to be in a database before you can specify a field trigger. It's actually called "Field Validation" in the table designer. Just open up a database and right click on a table and choose modify. You should see a "Field Validation" section. This is where you specify the field level triggers.
Tim Westmoreland
Software Engineer
Skyline Technologies, Inc.
"Upper classes are a nation's past; the middle class is its future." - Ayn Rand, Russian-born author (1905-1982).