Hi,
I need to export nested XML files i.e. with parent and child fields from 2 different queries, I can perform the action from 2 tables that have a relationship created between them via VB scripts and the structure is what I want.
My issue is that I cannot export one of the tables as an XML so to get around this I created a query that extracts the key fields I require for another application's processing and this needs an XML file
the second file needs to also be a query as it is looking up a multi-value field used in a form / table (used for ease of assigning multiple people to a task) and then placing extra details such as full name, email address and mobile number etc. in the query
does anyone have any recommendations how I can get these 2 files 'nested' ?
regards
Jason