Hi, I want to get all inventory items recently ordered by one debtor regardless of order type so I can make a display on our website of recently ordered products. This can then be used to add items to a favourites list or re-order group.
Is there a plugin for this, or do I need to do a table join of some sort?
If I need to do a table join on the SQL, which tables would I join?
Thanks for all your help.
Cheers