Let you know how it works out...
At 12:48 PM 7/15/98 -0700, you wrote:
>Ian Pizey wrote:
>> It should look like this.
>> OLD emerald database pre consolidation ----- into ----- new call details
>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. (email@example.com)
> IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs
> Internet Solutions for Today | http://www.iea-software.com
Technet of Kenora Inc.
924 5th Street South
Kenora, ON P9N 1L8