create view v_OrganizationDetailType as
select Type_name, Org_name, Org_address, Org_tel_no, Org_fax_no, Org_email, Org_description
from OrganizationType inner join OrganizationDetail on OrganizationType.Type_application_id =OrganizationDetail.Type_application_id
go

create trigger tr_v_OrganizationDetailType on v_OrganizationDetailType instead of insert as
BEGIN
insert OrganizationType (Type_name)
select distinct inserted.Type_name
from inserted left join OrganizationType on inserted.Type_name = OrganizationType.Type_name
where OrganizationType.Type_name IS NULL /*** Exclude Organization Types already in the table ***/

insert OrganizationDetail (Org_name, Org_address, Org_tel_no, Org_fax_no, Org_email, Org_description, Type_application_id)
select distinct inserted.Org_name, inserted.Org_address, inserted.Org_tel_no,
inserted.Org_fax_no, inserted.Org_email, inserted.Org_description, OrganizationType.Type_application_id
from inserted inner join OrganizationType on inserted.Type_name = OrganizationType.Type_name
left join OrganizationDetail on inserted.Org_name = OrganizationDetail.Org_name
and inserted.Org_address = OrganizationDetail.Org_address
and inserted.Org_tel_no = OrganizationDetail.Org_tel_no
and inserted.Org_fax_no = OrganizationDetail.Org_fax_no
and inserted.Org_email = OrganizationDetail.Org_email
and inserted.Org_description = OrganizationDetail.Org_description
where OrganizationDetail.Org_name IS NULL /*** Exclude Organization Detail already in the table ***/

END -- trigger def
go

insert v_OrganizationDetailType
select 'PTM', 'Sequ Inspection', 'Cheras', '0343234321', '0343234322', 'Sequ@inspec.com', 'Oil and Gas' UNION
select 'PTM', 'Alpha', 'Bangi', '0344567654', '0344567653', 'Alpha@yahoo.com', 'Hospitality Consultant'