vendredi 27 février 2015

Display a one-to-many relationship in one row


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