See this script. It creates a new table called CallDetails and
replaces the old trigger to insert a copy of the stop record
into the CalLDetails table in real time. It only works with
SQL Server. I don't know how to do this with MS Access (you
didn't mention which DB type you were using, though).
Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc. www.iea-software.com