strShape = _
" SHAPE APPEND " & _
" New adVarWChar(8) As STAFF_CODE, " & _
" New adVarWChar(20) As STAFF_NAME, " & _
" ((SHAPE APPEND " & _
" New adVarWChar(8) As SALESMAN_CODE, " & _
" New adVarWChar(10) As MEMBER_CODE, " & _
" New adVarWChar(40) As MEMBER_NAME, " & _
" New adVarWChar(11) As INVOICE_NO, " & _
" New adDate as TRANS_DATE, " & _
" New adCurrency As SALESMAN_COMM_VOL, " & _
" New adCurrency As SALESMAN_COMM_AMT, " & _
" New adCurrency As INVOICE_AMOUNT) " & _
" RELATE STAFF_CODE to SALESMAN_CODE) As Child "
this is only master relate to Detail in "Shape" but how to define Master relate to Detail1 relate to Detail2.... i mean more than 2 layer? how to write it?
" SHAPE APPEND " & _
" New adVarWChar(8) As STAFF_CODE, " & _
" New adVarWChar(20) As STAFF_NAME, " & _
" ((SHAPE APPEND " & _
" New adVarWChar(8) As SALESMAN_CODE, " & _
" New adVarWChar(10) As MEMBER_CODE, " & _
" New adVarWChar(40) As MEMBER_NAME, " & _
" New adVarWChar(11) As INVOICE_NO, " & _
" New adDate as TRANS_DATE, " & _
" New adCurrency As SALESMAN_COMM_VOL, " & _
" New adCurrency As SALESMAN_COMM_AMT, " & _
" New adCurrency As INVOICE_AMOUNT) " & _
" RELATE STAFF_CODE to SALESMAN_CODE) As Child "
this is only master relate to Detail in "Shape" but how to define Master relate to Detail1 relate to Detail2.... i mean more than 2 layer? how to write it?
