>Hello Everyone,
>
>I hope I have what is an easy question. First, I'm new to all this XML stuff, so I'm not even sure if I have the terminology correct, but what I need to be able to do is submit summary T4 information (which is employee pay information for tax purposes in Canada) to Revenue Canada in XML format. I've been looking at XMLAdapter, and it doesn't look too difficult, but I have one problem: I have to submit information with what I would call nested or group tags, but the data all comes from one table.
>
>Here is an example of the format they want:
>
>
><T619>
> <rpt_tcd>A</rpt_tcd>
> <lang_cd>E</lang_cd>
> <TRNMTR_NM>
> <l1_nm>Your Data</l1_nm>
> <l2_nm>Your Data</l2_nm>
> </TRNMTR_NM>
> <TRNMTR_ADDR>
> <addr_l1_txt>Your Data</addr_l1_txt>
> <addr_l2_txt>Your Data</addr_l2_txt>
> <cty_nm>Your Data</cty_nm>
> <cntry_cd>111</cntry_cd>
> <prov_cd>ON</prov_cd>
> <pstl_cd>Your Data</pstl_cd>
> </TRNMTR_ADDR>
> <CNTC>
> <cntc_nm>Your Data</cntc_nm>
> <cntc_area_cd>000</cntc_area_cd>
> <cntc_phn_nbr>000-0000</cntc_phn_nbr>
> <cntc_extn_nbr>0</cntc_extn_nbr>
> <cntc_email_area>Your Data</cntc_email_area>
> </CNTC>
></T619>
>
>
>The above is the submission header information they want to see. It is basically a single record. The actual T4 data also requires similar nested tags, in which similar data from a single record is grouped under 'group' tags.
>
>So the question I have is can XMLAdapater create nested or 'group' tags like this:
> <TRNMTR_NM>
> <l1_nm>Your Data</l1_nm>
> <l2_nm>Your Data</l2_nm>
> </TRNMTR_NM>
> <TRNMTR_ADDR>
> <addr_l1_txt>Your Data</addr_l1_txt>
> <prov_cd>ON</prov_cd>
> </TRNMTR_ADDR>
>
when it does not involve a parent/child relation, but is just a single table?
>
>If so, how the heck do I do it?
>
>Thanks in advance! Any help will be greatly appreciated.
>Aron
With a single table, textmerge or msxml.domdocument processing sounds to be easier.
Cetin