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
table
would work.
> 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
append
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. (daler@iea.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.emerald.iea.com