oops

insert into forms

select 1 , 'Login' union

select 2 , 'Main Form'

thats what happens when you rush

oops

should be

insert into forms

select 1 , 'Login' union

select 1 , 'Main Form'

and

select

 f.FormName

,  b.buttonName

,  '' as LabelName

from   forms f

inner join buttons b on b.fid = f.fid

union

select

 f.FormName

,  ''...

Hi,

is this what you want ?

drop table forms

drop table labels

drop table buttons

go

create table forms ( fid int , formName varchar(20))

create table buttons ( fid int , bid int , buttonName...

All,

thanks for your input.

I will work on a variation of Lee's stored proc and stick with the trigger until I get it working

Thanks for everything

gareth

Phil,

yes, brilliant idea unfortunatelty the schema is locked down and cant be changed ( well at least for next 12 months).

Lee,

I am unable to lock the table because it is...

Lee,

ok,  I'm not sure this would work, if two users were both executing procedure  and filling table at same time then this

SELECT new.cntr

    FROM   myTable new

    WHERE...