I have a "one to many" relationship in two tables:
Table "products" contains: product_id, product_descr
Table "packing" contains: product_id, package_id, package_desc
One product has often more than one package. I want to create a query in Microsoft Access, where I get all the package options for one product in one row:
product_id package_id1 package_desc1 packageid2 package_desc2 packageid_n package desc_n
The products do have a different number of packages, it's not a fixed number.
Aucun commentaire:
Enregistrer un commentaire