auto fill to master detail grid

[lamany77]

Dear all
i've
table A
table B
table C
table D

table A record :

invno totalqty

inv1 6

inv2 2

table B record :

invno code name qty

inv1 001 name1 1
inv1 002 name2 2
inv1 003 name3 3

inv2 001 name1 2

table C

invno totalqty

inv1 6

inv2 2

table D record (blank) :

invno code name qty

---

i've make autofill from table A to table C,
but i'm confuse to make from B to table D..
how do i autofill table from B to D.

i meant when i click the invno of table C, it will populate on grid detail and data is taken from table B.

thank you

[Webmaster]

Create Dynamic Selection List with the parent field as C.invno and child field as D.invno. Setup lookup table and AutoFill for D.invno using table B as lookup table.