Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SHAPE APPEND PROBLEM

Status
Not open for further replies.

v032115b

MIS
Jul 3, 2002
9
HK
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?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top