Select a record in one field and also select records from other field with condition

[#1]

Dear All,

Greetings !!!

I need help in writing a macro and the scenario for the same is:

(Attached the sample application)

1. Macro should select the ST ID one by one.

2. If ST ID is 1 the it shold select 2, 4, and 6 son records

and if ST ID=3 the it should select all the records under three one by one.

After selecting with above conditions it should save the report in the PDF format and save in the perticular path.

The report is already created under report section RP01

Regards,

Veman