Your solution is simple. Don't run consolidation and everything
will be great. :) If the FBI is coming to your door once a month
I would say you might want to choose your customers a little better. :)
> Both of MY reasons have nothing to do with Emerald billing structure.
> Perhaps the easiest way to accomplish my goal is to set up a trigger on the
> calls table that inserts an identical record into the calls-keep database
> or some such thing. I can stumble around SQL so I should be able to get
> any info I need from there and be able to cut/paste it to a user if necessary.
Creating a trigger to move specific fields in a stop record to another
> Help on such a trigger would be welcome :)
Righ Click on the calls table, select triggers, and it will show you the
current trigger. You'll need to create your second table, and then
to the trigger something like:
Insert Into DupCalls(UserName, CallDate, AcctSessionTime)
Values (inserted.UserName, Inserted.CallDate, Inserted.AcctSessionTime)
The fields depend on which fields you want into the dup table.
-- Dale E. Reed Jr. (email@example.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.emerald.iea.com