Triggers do not create objects. If you are creating objects on the fly, your design is flawed.
As for your trigger:
CREATE TRIGGER dbo.trigger_name
AFTER INSERT, UPDATE
SET status_of_application = 'Approved'
FROM dbo.registration As r
JOIN inserted As i
ON r.common_field = i.common_field
WHERE i.employment_status = 'Employed'
AND i.gross_monthly_income = 4000
thanks a lot of helping me out. But for some reason I am not able to update the status in the registration table to Approved using the trigger. Or am I doing something wrong here. I am supposed to save the trigger under applicant table, execute it and close it then go to registration table, refresh it and am supposed to see the updated status rite?
But when I just do a simple update statement, the status is changed. What could I be doing wrongly here? Any help? thanks...