I was trying to use the server side to do the processing side. I'll
try as you suggest and use DISTINCT and then try to set it to a
variable. I've got my tutroials next to me.
Thanks,
Hugh

--- In IBObjects@y..., "mmenaz" <mmenaz@l...> wrote:
> It seems that the select statement, that should return only one
matching row, is returning more than one.
> This way, the statement:
> SET SPECIMENID = Multiple values
> raises the error.
> Try "DISTINCT" to get only one (if it's returning multiple rows
with the same value), or revise your database design.
> You could also retrieve the value you want to set in a complex
query and set it to a variable, and then use that variable in the
UPDATE statement.
> Just some ideas...
> Regards
> Marco Menardi
>
> --- In IBObjects@y..., Hugh Johnson <hjohnson@p...> wrote:
> > Hello,
> > I am trying to use a trigger to update one table with a field
in another
> > table after it is inserted. I try to update the field