Adding multiple child records to a parent record

Hi Kevin 

I understand you have [RFQ]<[Related RFQ]

In the [RFQ] table you need to have a Field to select the active or closed RFQ.

Then you need to add a lookup fiend in you [Related RFQ] table to bring the [Active/Closed] Field you created.

Then you use the set up of the Drop-Down Field .










In the conditional values you select the look up  [Active/Closed] Field you created.

Good luck