How do I join the Catalog section table with the product section table in MS access? What is the key I need to use? The magic number field doesnt help at all. I need to extract out fields which are in both table per product but it not been straight forward.
-
Bantam -
You join the [Catalog Section].[nSectionID] to [Product].[nParentSectionID].
RegardsJan Strassen, Mole End Software - Plugins and Reports for Actinic V4 to V11, Sellerdeck V11 to V2018, Sellerdeck Cloud
Visit our facebook page for the latest news and special offers from Mole End
Top Quality Integrated label paper for Actinic and Sellerdeck
A4 Paper with one or two peel off labels, free reports available for our customers
Product Mash for Sellerdeck
Link to Google Shopping and other channels, increase sales traffic, prices from £29.95
Multichannel order processing
Process Actinic, Sellerdeck, Amazon, Ebay, Playtrade orders with a single program, low cost lite version now available from £19.95
Comment