I have created the following trigger. However I would like both of the fields inserted into the same record. The way I have created this trigger, it is inserting each of my fields into a new record, not both fields into the same record.
CREATE TRIGGER CreateRecordInRADiag ON [dbo].[RAItemsDetail]
INSERT INTO RADiag (RADiag_RAItemsDetailID)
SELECT RAItemsID FROM INSERTED;
INSERT INTO RADiag (RADiagRANumber)
SELECT RAItemsRAnumber FROM INSERTED;