Create a Database Called EmeraldCallDetails. Restore your calls table
into that database and create the CallDetails table in there as well.
Then do the Insert into CallDetails from Calls to put the records you
want in. Finally, delete the CallsTable from the new database.
Now, just modify the trigger, so that its like this:
Insert into EmeraldCallDetails..CallDetails(field, field,)
VALUES (value, value)
You can just adding the "EmeraldCallDetails.." in front of
the table name in the Emerald database, Calls table trigger.
This has the advantage of keeping the data seperated.
-- Dale E. Reed Jr. (firstname.lastname@example.org)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.iea-software.com