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
>> table
>
>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. (daler@iea-software.com)
>_________________________________________________________________
> IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs
> Internet Solutions for Today | http://www.iea-software.com
>
__________________________________
Ian Pizey
Technet of Kenora Inc.
924 5th Street South
Kenora, ON P9N 1L8
Ph 807-468-8900
Fx 807-468-7700
email:ifpizey@kenora.com