Part of my app hold a company's switchboard number. People linked with that company can also have a direct dial (or other) phone number. When the switchboard number is changed I have two different views from users. One group (in which I number myself) will wipe the person's number and replace with the new switchboard number. The other group will leave the person's number alone.

Neither view is right and the problem is currently handled by poping up a form which allows the choice of what is modified.

I'm hoping to alter to an after update trigger for the switchboard number but it would be nice to still give the users the choice of wether to replace the people's numbers with the new switchboard number or not.

Is there a way to get user interaction into a trigger?

Roy Lambert

Roy,

<< Is there a way to get user interaction into a trigger? >>

Yep.  Just write an external module that implements a function that does so,
and then call this function from the trigger.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim

Just what I thought - after I'd posted naturally


Roy Lambert