structure

CREATE TABLE orderheader
(id INT)

CREATE TABLE orderaudits
(id INT,
OrderHeader_ID INT,
Risk_Rating INT,
Investor_Name nvarchar(50))

CREATE TABLE orderfindings
(id INT,
Prnt_ID INT,
Finding_nbr CHAR(10)
)

CREATE TABLE orderagencies
(id INT,
Prnt_ID INT,
Agency_nbr CHAR(10)
)

INSERT INTO orderheader
VALUES (1)
--------------------------------------------------
INSERT INTO orderaudits
VALUES (1,1,1, 'FM')
INSERT INTO orderaudits
VALUES (2,1,1, 'FM')
INSERT INTO orderaudits
VALUES (3,1,1, 'FM')
INSERT INTO orderaudits
VALUES (4,1,1, 'FM')
INSERT INTO orderaudits
VALUES (5,1,1, 'FM')
INSERT INTO orderaudits
VALUES (6,1,2, 'FM')
INSERT INTO orderaudits
VALUES (7,1,2, 'FM')
INSERT INTO orderaudits
VALUES (8,1,2, 'FM')
INSERT INTO orderaudits
VALUES (9,1,2, 'FM')
INSERT INTO orderaudits
VALUES (10,1,2, 'FM')
-----------------------------------------
INSERT INTO orderfindings
VALUES (1,1, '100')
INSERT INTO orderfindings
VALUES (2,2, '100')
INSERT INTO orderfindings
VALUES (3,3, '100')
INSERT INTO orderfindings
VALUES (4,4, '100')
INSERT INTO orderfindings
VALUES (5,4, '100')
INSERT INTO orderfindings
VALUES (6,5, '100')
INSERT INTO orderfindings
VALUES (7,8, '100')
INSERT INTO orderfindings
VALUES (8,9, '100')
-------------------------------------
INSERT INTO orderagencies
VALUES (1,1, '100')
INSERT INTO orderagencies
VALUES (2,2, '100')
INSERT INTO orderagencies
VALUES (3,4, '100')
INSERT INTO orderagencies
VALUES (4,6, '100')
INSERT INTO orderagencies
VALUES (5,9, '100')
INSERT INTO orderagencies
VALUES (6,10, '100')