I'm converting from ACCESS to XML, I'm able to do this for an ACCESS database but can't figure out how to do it with XML, basically, how do I update an xml file (file3),based on rows selected in grids 1 and 2?
For example when I select GBR (Receiver_ID = 2) from the grid1 and 1305 from grid2 (Prop_NSN_ID = 1) how do I add the ID values to file 3 in the same row?
File 1 (Data in Grid1 users will select)Nations
<Root>
<Row><Receiver_ID>1</Receiver_ID>
<Description>FRA</Description>
</Row>
<Row><Receiver_ID>2</Receiver_ID>
<Description>GBR</Description>
</Row>
<Row>
<Receiver_ID>3</Receiver_ID>
<Description>NLD</Description>
</Row>
<Row>
<Receiver_ID>4</Receiver_ID>
<Description>DEU</Description>
</Row>
<Row><Receiver_ID>5</Receiver_ID>
<Description>USA</Description>
</Row>
</Root>
File 2 (Data in Grid2 users will select)Prop_NSN
<Root>
<Row>
<Prop_NSN_ID>1</Prop_NSN_ID>
<Description>1305</Description>
</Row>
<Row>
<Prop_NSN_ID>1</Prop_NSN_ID>
<Description>1307</Description>
</Row>
<Row>
<Prop_NSN_ID>1</Prop_NSN_ID>
<Description>1309</Description>
</Row>
</Root>
File 3 (File to be updated) - Link_Table
<Root>
<Row>
<Receiver_ID>2</Receiver_ID>
<Prop_NSN_ID>1</Prop_NSN_ID>
</Row>
</Root>
Thanks,
Victor