I need to dig into the Access database to export orders in a specific fashion.
I can find the client and the products ordered, but where is the orderd product options table? Anyones know?
eg.
I can find Joe Blogs and deliver address etc
I can find he ordered the Great Expectations Book
I can't find if he ordered the hard back or soft back (product option)
On a side note, what fields/values should I be looking for orders received with a payment against them, but not completed? eg I haven't delivered them yet.
I can find the client and the products ordered, but where is the orderd product options table? Anyones know?
eg.
I can find Joe Blogs and deliver address etc
I can find he ordered the Great Expectations Book
I can't find if he ordered the hard back or soft back (product option)
On a side note, what fields/values should I be looking for orders received with a payment against them, but not completed? eg I haven't delivered them yet.