|
| Hi
I have a Access 2003 DB that has primarily two main tables tblPurchOrder &
tblPurchOrderDetails. There is a one to many relationship between the two
tables.
the fields in the two tables are as follows:
tblPurchOrder
PurchOrderID
PurchOrderDate
SupplierID
Comments
tblPurchOrderDetails
PurchOrderDetailID
PurchOrderID
ProductID
Qty
Units
UnitCost
The data entry form has two parts to it corresp to the above two tables.
the line items (what is being ordered) is in the table tblOrderDetails.
I want to be able to export the two tables as XML and have a xsl doc that
will generate a XML doc that arranges the data in the two tables for a given
PurchOrderID in the same or similar format as how the form is arranged.
Is xsl the way to go? Or is there some other way of getting the final
result that I am after?
If anybody could give me a clue I would really appreciate it.
Kind regards
Ross Petersen
|
|