create delete cascade

if you delete dependant record then child data also deleted 
ALTER TABLE tbl_UARRecord

ADD CONSTRAINT FK_tbl_UARRecord_tbl_UploadCycle

    FOREIGN KEY (UploadCycleId)

    REFERENCES tbl_UploadCycle(UploadCycleId)

    ON DELETE CASCADE;