How to Data fetch one doctype child table to second doctype child table

[hidayat_ali]

First Doctype Image

Second Doctype Image

Customer Brand Items Fetch in Sales Order.
Ex: open sales order after the select customer Demo123 only show 2 items in sales order child table