{"id":4023,"date":"2026-02-17T22:01:37","date_gmt":"2026-02-17T22:01:37","guid":{"rendered":"https:\/\/datissima.tech\/?p=4023"},"modified":"2026-02-17T22:05:21","modified_gmt":"2026-02-17T22:05:21","slug":"7-formularios-con-superpoderes-subformularios-y-relaciones","status":"publish","type":"post","link":"https:\/\/datissima.tech\/ca\/7-formularios-con-superpoderes-subformularios-y-relaciones\/","title":{"rendered":"7. Formularis amb superpoders: subformularis i relacions"},"content":{"rendered":"<div data-elementor-type=\"wp-post\" data-elementor-id=\"4023\" class=\"elementor elementor-4023\" data-elementor-post-type=\"post\">\n\t\t\t\t<div class=\"elementor-element elementor-element-b8dd036 e-flex e-con-boxed e-con e-parent\" data-id=\"b8dd036\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-011258e elementor-widget elementor-widget-text-editor\" data-id=\"011258e\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><style>\na {\n    text-decoration: none;\n    color: #464feb;\n}\ntr th, tr td {\n    border: 1px solid #e6e6e6;\n}\ntr th {\n    background-color: #f5f5f5;\n}\n<\/style><\/p><div><div class=\"paragraph-in-scc-markdown-text ___1ngh792 ftgm304 f1iaxwol\"><div class=\"paragraph-in-scc-markdown-text ___1ngh792 ftgm304 f1iaxwol\"><div class=\"paragraph-in-scc-markdown-text ___1ngh792 ftgm304 f1iaxwol\"><div class=\"paragraph-in-scc-markdown-text ___1ngh792 ftgm304 f1iaxwol\"><div><div class=\"paragraph-in-scc-markdown-text ___1ngh792 ftgm304 f1iaxwol\">\u00bf<strong>Imagines poder veure, dins del mateix formulari, dades de dues taules diferents alhora?<\/strong> Aix\u00f2 \u00e9s justament el que aconseguir\u00e0s amb els <strong>subformularis<\/strong>. En termes simples, un <strong>subformulari<\/strong> ca <strong>un formulari ficat dins d&#039;un altre formulari<\/strong>. Se sol parlar de <strong>formulari principal<\/strong> (el que \u201ccont\u00e9\u201d) i <strong>subformulari<\/strong> (el formulari \u201ccontingut\u201d). Aquesta combinaci\u00f3 \u00e9s tan poderosa que de vegades se&#039;n diu formulari <strong>mestre\/detall<\/strong> o <strong>principal\/secundari<\/strong>.<\/div><div class=\"paragraph-in-scc-markdown-text ___1ngh792 ftgm304 f1iaxwol\"><strong>Per qu\u00e8 serveixen els subformularis?<\/strong> <strong>Per veure f\u00e0cilment informaci\u00f3 relacionada<\/strong> sense canviar de pantalla. S\u00f3n ideals quan tens <strong>taules amb relacions d&#039;\u201cun a diversos\u201d<\/strong> i vols veure en una sola ullada les dades del costat \u201cun\u201d i del costat \u201cdiversos\u201d simult\u00e0niament. Per exemple, a la base de dades de la nostra biblioteca, <strong>un soci pot tenir diversos pr\u00e9stecs<\/strong>. En un formulari normal de Socis, potser nom\u00e9s veuries les dades generals del soci. Amb un <strong>subformulari<\/strong>, pots mostrar <strong>dins d&#039;aquesta mateixa finestra tots els pr\u00e9stecs (els \u201cdiversos\u201d) associats a aquest soci (l&#039;\u201cun\u201d)<\/strong>. Resultat: una ullada completa, sense haver d&#039;anar obrint i tancant taules.<\/div><div class=\"paragraph-in-scc-markdown-text ___1ngh792 ftgm304 f1iaxwol\">Pensa aix\u00ed: <strong>el formulari principal \u00e9s el \u201cprotagonista\u201d i el subformulari \u00e9s el seu \u201ccompany\u201d fidel<\/strong>. El formulari principal mostra un registre alhora (per exemple, la fitxa d&#039;un soci), mentre que el subformulari us acompanya mostrant <strong>diversos registres relacionats<\/strong> amb aquest mateix element (els pr\u00e9stecs del soci). Tots dos estan connectats per la <strong>relaci\u00f3<\/strong> pr\u00e8viament establerta entre les taules. En el nostre cas, la relaci\u00f3 la vam establir a la # dient que la taula <em>Pr\u00e9stecs<\/em> t\u00e9 un camp que identifica el soci (per exemple, <em>ID_soci<\/em>). Gr\u00e0cies a aix\u00f2, Access \u201csap\u201d quins pr\u00e9stecs pertanyen a cada persona i pot enlla\u00e7ar la informaci\u00f3 autom\u00e0ticament.<\/div><\/div><\/div><\/div><\/div><\/div><\/div>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-bcfab25 e-con-full e-flex e-con e-child\" data-id=\"bcfab25\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t<div class=\"elementor-element elementor-element-471d410 e-con-full e-flex e-con e-child\" data-id=\"471d410\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-bc70026 elementor-widget elementor-widget-heading\" data-id=\"bc70026\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Tot en un<\/h4>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-09bf88c elementor-widget elementor-widget-text-editor\" data-id=\"09bf88c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Els subformularis et permeten veure\u00a0<strong>dos nivells d&#039;informaci\u00f3 a la<\/strong> <strong>vegada<\/strong>. Per exemple, les dades dun soci juntament amb els seus pr\u00e9stecs sense sortir del formulari.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-59893e1 e-con-full e-flex e-con e-child\" data-id=\"59893e1\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-2ee4af8 elementor-widget elementor-widget-heading\" data-id=\"2ee4af8\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Informaci\u00f3 vinculada<\/h4>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3794495 elementor-widget elementor-widget-text-editor\" data-id=\"3794495\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>El subformulari\u00a0<strong>sempre mostra els registres relacionats<\/strong> amb el registre que tinguis actiu al formulari principal. Si canvieu de soci al formulari principal, el subformulari actualitzar\u00e0 la llista de pr\u00e9stecs autom\u00e0ticament.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-32a1ae4 e-con-full e-flex e-con e-child\" data-id=\"32a1ae4\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-3021e3d elementor-widget elementor-widget-heading\" data-id=\"3021e3d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Per a relacions &quot;un a diversos&quot;\"<\/h4>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c1cf5d7 elementor-widget elementor-widget-text-editor\" data-id=\"c1cf5d7\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Els subformularis aprofiten les\u00a0<strong>relacions un-a-diversos<\/strong> que vas definir entre taules. S\u00f3n la millor eina per a casos en qu\u00e8 un element t\u00e9 molts associats (un soci amb molts pr\u00e9stecs, una comanda amb molts productes, etc.).<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-bd604db e-con-full e-flex e-con e-child\" data-id=\"bd604db\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-5b2dba5 elementor-widget elementor-widget-heading\" data-id=\"5b2dba5\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Estalvi de temps<\/h4>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ab22d42 elementor-widget elementor-widget-text-editor\" data-id=\"ab22d42\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Amb un subformulari\u00a0<strong>evites cerques manuals<\/strong>. No necessites obrir una altra taula ni fer consultes per veure les dades relacionades: el formulari principal i el subformulari s&#039;encarreguen de mostrar-les en conjunt.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7a7cacd elementor-widget elementor-widget-text-editor\" data-id=\"7a7cacd\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><style>\na {\n    text-decoration: none;\n    color: #464feb;\n}\ntr th, tr td {\n    border: 1px solid #e6e6e6;\n}\ntr th {\n    background-color: #f5f5f5;\n}\n<\/style><\/p><div><h2>Exemple pr\u00e0ctic: un soci i els seus pr\u00e9stecs<\/h2><div class=\"paragraph-in-scc-markdown-text ___1ngh792 ftgm304 f1iaxwol\">Seguint l&#039;exemple de la biblioteca, imaginem un <strong>formulari principal de \u201cSocis\u201d<\/strong> i un <strong>subformulari de \u201cPr\u00e9stecs\u201d<\/strong>. Quan obrim el formulari, veurem a la part superior les dades del soci (per exemple: nom, cognoms, email, etc.), i sota una <strong>llista dels pr\u00e9stecs d&#039;aquest soci en particular<\/strong> (per exemple: t\u00edtols dels llibres prestats, data de pr\u00e9stec, data de devoluci\u00f3, etc.).<\/div><div class=\"paragraph-in-scc-markdown-text ___1ngh792 ftgm304 f1iaxwol\">Suposa que tens aquestes dades a les teves taules:<\/div><ul><li class=\"___ccc16d0 fje8fi8 f1ng9h0j f1bwykku f18jd3zf\"><strong>Soci:<\/strong> <em>Ana L\u00f3pez<\/em> \u2013 <strong>Llibres prestats:<\/strong> <em>Cent anys de soledat<\/em> (15\/01\/2026) i <em>L&#039;ombra del vent<\/em> (01\/02\/2026).<\/li><li class=\"___ccc16d0 fje8fi8 f1ng9h0j f1bwykku f18jd3zf\"><strong>Soci:<\/strong> <em>Juan P\u00e9rez<\/em> \u2013 <strong>Llibres prestats:<\/strong> <em>El Hobbit<\/em> (25\/01\/2026).<\/li><\/ul><div class=\"paragraph-in-scc-markdown-text ___1ngh792 ftgm304 f1iaxwol\">Si consultes la fitxa de <em>Ana L\u00f3pez<\/em> amb el formulari de Socis, el subformulari de Pr\u00e9stecs mostrar\u00e0 <strong>dos registres<\/strong>: un per <em>\u201cCent anys de soledat\u201d<\/em> (prestat el 15\/01\/2026) i un altre per <em>\u201cL&#039;ombra del vent\u201d<\/em> (prestat el 01\/02\/2026). Si despr\u00e9s passes al registre de <em>Juan P\u00e9rez<\/em> al formulari principal, veur\u00e0s que <strong>el subformulari canvia autom\u00e0ticament<\/strong> per exhibir nom\u00e9s el registre de <em>\u201cEl Hobbit\u201d<\/em> (25\/01\/2026) que correspon a Joan. M\u00e0gia! \u2728 B\u00e9, en realitat \u00e9s l\u00f2gica de base de dades, per\u00f2 sembla m\u00e0gia perqu\u00e8 Access fa tota la feina bruta: detecta que <em>Juan P\u00e9rez<\/em> \u00e9s el soci actual i filtra el subformulari perqu\u00e8 nom\u00e9s vegis els seus pr\u00e9stecs. Si el subformulari <strong>no estigu\u00e9s vinculat<\/strong> correctament, veuries <strong>tots els pr\u00e9stecs de tots els socis alhora<\/strong>, la qual cosa seria un caos. Per aix\u00f2 \u00e9s important haver definit les <strong>relacions<\/strong> entre les taules abans d&#039;usar subformularis (en aquest cas, dir-li a Access que <em>Pr\u00e9stecs<\/em> est\u00e0 relacionat amb <em>Socis<\/em> a trav\u00e9s de l&#039;ID del soci).<\/div><h2>Com crear un formulari amb subformulari (pas a pas)<\/h2><div class=\"paragraph-in-scc-markdown-text ___1ngh792 ftgm304 f1iaxwol\">La manera m\u00e9s senzilla de construir aquest \u201cformulari doble\u201d \u00e9s usant el <strong>Assistent per a formularis<\/strong> d&#039;Access. Aquest assistent ens permet, en un sol proc\u00e9s, crear el formulari principal, el subformulari i que quedin <strong>correctament vinculats<\/strong>. Et guiar\u00e9 pels passos usant el nostre exemple de Socis (principal) amb Pr\u00e9stecs (secundari):<\/div><ol><li class=\"___ccc16d0 fje8fi8 f1ng9h0j f1bwykku f18jd3zf\">A la pestanya <strong>Crear<\/strong>, fes clic a <strong>Assistent per a formularis<\/strong>. S&#039;obre una finestra que us preguntar\u00e0 quina informaci\u00f3 voleu visualitzar.<\/li><li class=\"___ccc16d0 fje8fi8 f1ng9h0j f1bwykku f18jd3zf\"><strong>Primer, seleccioneu la taula del formulari principal<\/strong> (el costat \u201cun\u201d de la relaci\u00f3). En el nostre cas, tria <strong>Taula: Socis<\/strong>. Just a sota, veur\u00e0s la llista de <strong>Camps disponibles<\/strong> de la taula Socis. Com de costum, <strong>passa al costat dret els camps<\/strong> que vulguis veure al formulari del soci (per exemple, Nom, Cognoms, i Email del soci).<\/li><li class=\"___ccc16d0 fje8fi8 f1ng9h0j f1bwykku f18jd3zf\"><strong>Ara ve la part clau:<\/strong> sense tancar aquesta pantalla, cerca la llista desplegable que torna a dir <em>Taules\/Consultes<\/em> y <strong>selecciona la taula relacionada<\/strong> que cont\u00e9 els \u201cdiversos\u201d. En el nostre exemple, tria <strong>Taula: Pr\u00e9stecs<\/strong> (costat \u201cdiversos\u201d). Apareixeran els vostres camps a la llista. <strong>Trieu els camps<\/strong> que t&#039;interessen del pr\u00e9stec, per exemple <em>T\u00edtolDelLlibre<\/em>, <em>DataPr\u00e9stec<\/em> y <em>DataDevoluci\u00f3<\/em>, i passa&#039;ls a la dreta. Aquests seran els camps que es mostraran al subformulari.<\/li><li class=\"___ccc16d0 fje8fi8 f1ng9h0j f1bwykku f18jd3zf\">Clica <strong>Seg\u00fcent<\/strong>. Si les relacions entre les taules <em>Socis<\/em> y <em>Pr\u00e9stecs<\/em> estan ben definides, l&#039;assistent d&#039;Access us far\u00e0 la pregunta m\u00e0gica: <strong>\u201cCom voleu veure les dades?\u201d<\/strong>. T&#039;est\u00e0 preguntant b\u00e0sicament \u201cQuina \u00e9s la taula principal (la del costat un)?\u201d. Selecciona <strong>\u201cPer Socis\u201d<\/strong> (\u00e9s a dir, que els <em>Socis<\/em> seran el focus principal). En aquest moment, l&#039;assistent et mostra un diagrama d&#039;un formulari amb un requadre a dins, indicant que ent\u00e9n que crear\u00e0s un subformulari. (Si l&#039;assistent <strong>no<\/strong> et va fer la pregunta de com veure les dades, \u00e9s possible que no hagi reconegut la relaci\u00f3. En aquest cas, cancel\u00b7leu l&#039;assistent, revisau les relacions de les taules i torneu-ho a provar).<\/li><li class=\"___ccc16d0 fje8fi8 f1ng9h0j f1bwykku f18jd3zf\">A continuaci\u00f3, marca l&#039;opci\u00f3 <strong>\u201cFormulari amb subformularis\u201d<\/strong> i fes clic a <strong>Seg\u00fcent<\/strong>.<\/li><li class=\"___ccc16d0 fje8fi8 f1ng9h0j f1bwykku f18jd3zf\"><strong>Triar disseny del subformulari:<\/strong> et preguntar\u00e0 com vols que es mostri el subformulari dins del formulari principal. Aqu\u00ed tens dues opcions principals: <strong>Tabular<\/strong> (les dades disposades en files i columnes amb les seves cap\u00e7aleres, b\u00e0sicament amb aspecte de \u201ctauleta\u201d) o <strong>Justificat<\/strong> (com si cada registre del subformulari s&#039;hagu\u00e9s de veure m\u00e9s com un formulari individual). Per simplicitat, tria <strong>Full de dades<\/strong> (que \u00e9s similar al tabular i es veur\u00e0 com una llista tipus Excel). Clica <strong>Seg\u00fcent<\/strong>.<\/li><li class=\"___ccc16d0 fje8fi8 f1ng9h0j f1bwykku f18jd3zf\"><strong>Escull un estil visual<\/strong> que t&#039;agradi. Aix\u00f2 d\u00f3na un aspecte de color i font al formulari i subformulari. Pots previsualitzar diferents estils (Acc\u00e9s, Aspecte, Office, etc.) i triar el que prefereixis. Despr\u00e9s fes clic a <strong>Seg\u00fcent<\/strong>.<\/li><li class=\"___ccc16d0 fje8fi8 f1ng9h0j f1bwykku f18jd3zf\">Finalment, <strong>posa nom als teus formularis<\/strong>. Per exemple, digueu-li \u201cSocis\u201d al formulari principal i \u201cPr\u00e9stecs de Soci\u201d al subformulari, perqu\u00e8 quedi clar. Marqueu l&#039;opci\u00f3 d&#039;obrir el formulari <strong>en vista Formulari<\/strong> (aix\u00ed ho veurem funcionant immediatament) i fes clic a <strong>Finalitzar<\/strong>.<\/li><\/ol><div class=\"paragraph-in-scc-markdown-text ___1ngh792 ftgm304 f1iaxwol\">Tatxan! \ud83c\udf89 Access crear\u00e0 <strong>dos nous objectes de formulari<\/strong>: un principal anomenat <em>\u201cSocis\u201d<\/em> (en aquest exemple) i un altre que \u00e9s el subformulari (per exemple <em>\u201cPr\u00e9stecs de soci\u201d<\/em>). Obrir\u00e0 autom\u00e0ticament el formulari principal amb el subformulari incrustat. Observa com funciona: utilitza els botons de navegaci\u00f3 del formulari principal per moure&#039;t pels socis, i veur\u00e0s que el subformulari va canviant les dades per mostrar nom\u00e9s els pr\u00e9stecs de cada soci. \u00a1Ha adquirit un superpoder! \ud83d\ude0e Ara, en un sol formulari, veus tota la informaci\u00f3 <em>relacionada<\/em>.<\/div><h2>\u00daltims retocs i personalitzaci\u00f3 b\u00e0sica del subformulari<\/h2><div class=\"paragraph-in-scc-markdown-text ___1ngh792 ftgm304 f1iaxwol\">El millor de tot \u00e9s que el subformulari que es va crear <strong>\u00e9s, en el fons, un formulari m\u00e9s<\/strong>. Aix\u00f2 vol dir que <strong>pots personalitzar-lo igual que qualsevol altre formulari<\/strong>. Per exemple, si el subformulari apareix en forma de full de dades (files i columnes grises) per\u00f2 preferiu un aspecte m\u00e9s personalitzat, podeu obrir l&#039;objecte <em>\u201cPr\u00e9stecs de soci\u201d<\/em> des del panell de navegaci\u00f3 (com faries amb qualsevol formulari independent) i canviar-ne el disseny. Podries posar-ho en disseny Tabular tradicional, afegir colorets, negretes o el que vulguis, exactament igual que vas fer amb els teus altres formularis. Despr\u00e9s de tot, un subformulari no deixa de ser un formulari normal amb la <em>particularitat<\/em> que viu dins dun altre! Tamb\u00e9 podeu modificar directament algunes coses des de la vista Disseny o Presentaci\u00f3 del formulari principal: per exemple, fer m\u00e9s gran el requadre on viu el subformulari perqu\u00e8 hi c\u00e0piguen m\u00e9s files, o ajustar com s&#039;alineen les columnes del subformulari.<\/div><div class=\"paragraph-in-scc-markdown-text ___1ngh792 ftgm304 f1iaxwol\"><strong>En general, amb un formulari principal i el subformulari tindr\u00e0s una vista unificada de la informaci\u00f3 relacionada<\/strong>, el que millora molt lexperi\u00e8ncia de manejar dades a la teva base de dades. Ja no haur\u00e0s de fer malabars entre diverses taules: tot queda integrat a una sola pantalla. I recordeu, si en algun moment necessiteu crear un altre parell formulari-subformulari, podeu repetir els passos amb les taules que necessiteu (sempre que tingueu una relaci\u00f3 definida). En m\u00faltiples situacions reals, els subformularis et faran la vida m\u00e9s f\u00e0cil: <em>comandes i detalls de comandes, factures i partides<\/em>, <em>classes i alumnes<\/em>, <em>pacients i cites m\u00e8diques<\/em>, i un llarg etc\u00e8tera! En totes aquestes duples de dades amb relaci\u00f3 un a diversos, un subformulari pot ser el teu millor aliat.<\/div><\/div>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b12e6a4 elementor-align-center elementor-widget elementor-widget-button\" data-id=\"b12e6a4\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm\" href=\"#\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t\t\t\t<span class=\"elementor-button-text\">AUTOAVALUACI\u00d3<\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-95348aa elementor-widget elementor-widget-text-editor\" data-id=\"95348aa\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><style>\na {<br \/>    text-decoration: none;<br \/>    color: #464feb;<br \/>}<br \/>tr th, tr td {<br \/>    border: 1px solid #e6e6e6;<br \/>}<br \/>tr th {<br \/>    background-color: #f5f5f5;<br \/>}<br \/><\/style><\/p><div><hr \/><h3>Bibliografia i Webgrafia<\/h3><ul><li class=\"paragraph-in-scc-markdown-text ___1ngh792 ftgm304 f1iaxwol\">Suport t\u00e8cnic de Microsoft. (sf). <span style=\"color: #333333;\"><a style=\"color: #333333;\" href=\"https:\/\/support.microsoft.com\/es-es\/topic\/crear-un-formulario-que-contiene-un-subformulario-formulario-de-uno-a-varios-ddf3822f-8aba-49cb-831a-1e74d6f5f06b\"><em>Crear un formulari que cont\u00e9 un subformulari (formulari d&#039;un a m\u00e9s)<\/em><\/a><\/span>.<\/li><li class=\"paragraph-in-scc-markdown-text ___1ngh792 ftgm304 f1iaxwol\">Hern\u00e1ndez, A. (2026). <em><span style=\"color: #333333;\"><a style=\"color: #333333;\" href=\"https:\/\/internetpasoapaso.com\/insertar-subformulario-access\/\">Com crear un subformulari en una base de dades del Microsoft Access des de zero?<\/a><\/span>\u00a0<\/em><\/li><li class=\"___ccc16d0 fje8fi8 f1ng9h0j f1bwykku f18jd3zf\"><div class=\"paragraph-in-scc-markdown-text ___1ngh792 ftgm304 f1iaxwol\">Almi\u00f1ana Navarro, A. (2021, 20 de setembre). <span style=\"color: #333333;\"><a style=\"color: #333333;\" href=\"https:\/\/aprendecomohacerlo.com\/crear-subformularios-access-forma-correcta\"><em>Com es creen els subformularis a l&#039;Access de forma correcta?<\/em> A <em>Apr\u00e8nComFer-ho.com<\/em><\/a><\/span>.\u00a0<\/div><\/li><li class=\"___ccc16d0 fje8fi8 f1ng9h0j f1bwykku f18jd3zf\"><div class=\"paragraph-in-scc-markdown-text ___1ngh792 ftgm304 f1iaxwol\">Westdary. (2025, 29 d&#039;abril). <span style=\"color: #333333;\"><a style=\"color: #333333;\" href=\"https:\/\/dcinl.com\/como-hacer-un-subformulario-en-access\/\"><em>Com fer un subformulari a Access<\/em><\/a><\/span>. A <em>DCINL<\/em>.\u00a0<\/div><\/li><\/ul><\/div>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>","protected":false},"excerpt":{"rendered":"<p>\u00bfImaginas poder ver, dentro del mismo formulario, datos de dos tablas diferentes al mismo tiempo? Eso es justamente lo que lograr\u00e1s con los subformularios. En t\u00e9rminos simples, un subformulario es un formulario metido dentro de otro formulario. Se suele hablar de formulario principal (el que \u201ccontiene\u201d) y subformulario (el formulario \u201ccontenido\u201d). Esta combinaci\u00f3n es tan [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[24],"tags":[],"class_list":["post-4023","post","type-post","status-publish","format-standard","hentry","category-access"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>7. Formularios con superpoderes: subformularios y relaciones - Datissima<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/datissima.tech\/ca\/7-formularios-con-superpoderes-subformularios-y-relaciones\/\" \/>\n<meta property=\"og:locale\" content=\"ca_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"7. Formularios con superpoderes: subformularios y relaciones - Datissima\" \/>\n<meta property=\"og:description\" content=\"\u00bfImaginas poder ver, dentro del mismo formulario, datos de dos tablas diferentes al mismo tiempo? Eso es justamente lo que lograr\u00e1s con los subformularios. En t\u00e9rminos simples, un subformulario es un formulario metido dentro de otro formulario. Se suele hablar de formulario principal (el que \u201ccontiene\u201d) y subformulario (el formulario \u201ccontenido\u201d). Esta combinaci\u00f3n es tan [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datissima.tech\/ca\/7-formularios-con-superpoderes-subformularios-y-relaciones\/\" \/>\n<meta property=\"og:site_name\" content=\"Datissima\" \/>\n<meta property=\"article:published_time\" content=\"2026-02-17T22:01:37+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-02-17T22:05:21+00:00\" \/>\n<meta name=\"author\" content=\"Beatriz Romera\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrit per\" \/>\n\t<meta name=\"twitter:data1\" content=\"Beatriz Romera\" \/>\n\t<meta name=\"twitter:label2\" content=\"Temps estimat de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 minuts\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/datissima.tech\\\/ca\\\/7-formularios-con-superpoderes-subformularios-y-relaciones\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/datissima.tech\\\/ca\\\/7-formularios-con-superpoderes-subformularios-y-relaciones\\\/\"},\"author\":{\"name\":\"Beatriz Romera\",\"@id\":\"https:\\\/\\\/datissima.tech\\\/ca\\\/#\\\/schema\\\/person\\\/f121c27c1a4a45b61c67e97d00d586de\"},\"headline\":\"7. Formularios con superpoderes: subformularios y relaciones\",\"datePublished\":\"2026-02-17T22:01:37+00:00\",\"dateModified\":\"2026-02-17T22:05:21+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/datissima.tech\\\/ca\\\/7-formularios-con-superpoderes-subformularios-y-relaciones\\\/\"},\"wordCount\":1741,\"publisher\":{\"@id\":\"https:\\\/\\\/datissima.tech\\\/ca\\\/#\\\/schema\\\/person\\\/f121c27c1a4a45b61c67e97d00d586de\"},\"articleSection\":[\"Access\"],\"inLanguage\":\"ca\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/datissima.tech\\\/ca\\\/7-formularios-con-superpoderes-subformularios-y-relaciones\\\/\",\"url\":\"https:\\\/\\\/datissima.tech\\\/ca\\\/7-formularios-con-superpoderes-subformularios-y-relaciones\\\/\",\"name\":\"7. Formularios con superpoderes: subformularios y relaciones - Datissima\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/datissima.tech\\\/ca\\\/#website\"},\"datePublished\":\"2026-02-17T22:01:37+00:00\",\"dateModified\":\"2026-02-17T22:05:21+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/datissima.tech\\\/ca\\\/7-formularios-con-superpoderes-subformularios-y-relaciones\\\/#breadcrumb\"},\"inLanguage\":\"ca\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/datissima.tech\\\/ca\\\/7-formularios-con-superpoderes-subformularios-y-relaciones\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/datissima.tech\\\/ca\\\/7-formularios-con-superpoderes-subformularios-y-relaciones\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\\\/\\\/datissima.tech\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"7. Formularios con superpoderes: subformularios y relaciones\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/datissima.tech\\\/ca\\\/#website\",\"url\":\"https:\\\/\\\/datissima.tech\\\/ca\\\/\",\"name\":\"Datissima\",\"description\":\"Consultor\u00eda de procesos y cultura del datos\",\"publisher\":{\"@id\":\"https:\\\/\\\/datissima.tech\\\/ca\\\/#\\\/schema\\\/person\\\/f121c27c1a4a45b61c67e97d00d586de\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/datissima.tech\\\/ca\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ca\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/datissima.tech\\\/ca\\\/#\\\/schema\\\/person\\\/f121c27c1a4a45b61c67e97d00d586de\",\"name\":\"Beatriz Romera\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ca\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/46cc1207f6b15884a3edc270b3dfa4a004849f199e7253874c2838ed823ce914?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/46cc1207f6b15884a3edc270b3dfa4a004849f199e7253874c2838ed823ce914?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/46cc1207f6b15884a3edc270b3dfa4a004849f199e7253874c2838ed823ce914?s=96&d=mm&r=g\",\"caption\":\"Beatriz Romera\"},\"logo\":{\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/46cc1207f6b15884a3edc270b3dfa4a004849f199e7253874c2838ed823ce914?s=96&d=mm&r=g\"},\"sameAs\":[\"www.linkedin.com\\\/in\\\/bromera\",\"https:\\\/\\\/youtube.com\\\/@datissima?si=y2zjW3d7mbH2YgPF\"],\"url\":\"https:\\\/\\\/datissima.tech\\\/ca\\\/author\\\/admin\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"7. Formularios con superpoderes: subformularios y relaciones - Datissima","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/datissima.tech\/ca\/7-formularios-con-superpoderes-subformularios-y-relaciones\/","og_locale":"ca_ES","og_type":"article","og_title":"7. Formularios con superpoderes: subformularios y relaciones - Datissima","og_description":"\u00bfImaginas poder ver, dentro del mismo formulario, datos de dos tablas diferentes al mismo tiempo? Eso es justamente lo que lograr\u00e1s con los subformularios. En t\u00e9rminos simples, un subformulario es un formulario metido dentro de otro formulario. Se suele hablar de formulario principal (el que \u201ccontiene\u201d) y subformulario (el formulario \u201ccontenido\u201d). Esta combinaci\u00f3n es tan [&hellip;]","og_url":"https:\/\/datissima.tech\/ca\/7-formularios-con-superpoderes-subformularios-y-relaciones\/","og_site_name":"Datissima","article_published_time":"2026-02-17T22:01:37+00:00","article_modified_time":"2026-02-17T22:05:21+00:00","author":"Beatriz Romera","twitter_card":"summary_large_image","twitter_misc":{"Escrit per":"Beatriz Romera","Temps estimat de lectura":"8 minuts"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/datissima.tech\/ca\/7-formularios-con-superpoderes-subformularios-y-relaciones\/#article","isPartOf":{"@id":"https:\/\/datissima.tech\/ca\/7-formularios-con-superpoderes-subformularios-y-relaciones\/"},"author":{"name":"Beatriz Romera","@id":"https:\/\/datissima.tech\/ca\/#\/schema\/person\/f121c27c1a4a45b61c67e97d00d586de"},"headline":"7. Formularios con superpoderes: subformularios y relaciones","datePublished":"2026-02-17T22:01:37+00:00","dateModified":"2026-02-17T22:05:21+00:00","mainEntityOfPage":{"@id":"https:\/\/datissima.tech\/ca\/7-formularios-con-superpoderes-subformularios-y-relaciones\/"},"wordCount":1741,"publisher":{"@id":"https:\/\/datissima.tech\/ca\/#\/schema\/person\/f121c27c1a4a45b61c67e97d00d586de"},"articleSection":["Access"],"inLanguage":"ca"},{"@type":"WebPage","@id":"https:\/\/datissima.tech\/ca\/7-formularios-con-superpoderes-subformularios-y-relaciones\/","url":"https:\/\/datissima.tech\/ca\/7-formularios-con-superpoderes-subformularios-y-relaciones\/","name":"7. Formularios con superpoderes: subformularios y relaciones - Datissima","isPartOf":{"@id":"https:\/\/datissima.tech\/ca\/#website"},"datePublished":"2026-02-17T22:01:37+00:00","dateModified":"2026-02-17T22:05:21+00:00","breadcrumb":{"@id":"https:\/\/datissima.tech\/ca\/7-formularios-con-superpoderes-subformularios-y-relaciones\/#breadcrumb"},"inLanguage":"ca","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datissima.tech\/ca\/7-formularios-con-superpoderes-subformularios-y-relaciones\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/datissima.tech\/ca\/7-formularios-con-superpoderes-subformularios-y-relaciones\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/datissima.tech\/"},{"@type":"ListItem","position":2,"name":"7. Formularios con superpoderes: subformularios y relaciones"}]},{"@type":"WebSite","@id":"https:\/\/datissima.tech\/ca\/#website","url":"https:\/\/datissima.tech\/ca\/","name":"Datissima","description":"Consultoria de processos i cultura de les dades","publisher":{"@id":"https:\/\/datissima.tech\/ca\/#\/schema\/person\/f121c27c1a4a45b61c67e97d00d586de"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/datissima.tech\/ca\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ca"},{"@type":["Person","Organization"],"@id":"https:\/\/datissima.tech\/ca\/#\/schema\/person\/f121c27c1a4a45b61c67e97d00d586de","name":"Beatriz Romera","image":{"@type":"ImageObject","inLanguage":"ca","@id":"https:\/\/secure.gravatar.com\/avatar\/46cc1207f6b15884a3edc270b3dfa4a004849f199e7253874c2838ed823ce914?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/46cc1207f6b15884a3edc270b3dfa4a004849f199e7253874c2838ed823ce914?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/46cc1207f6b15884a3edc270b3dfa4a004849f199e7253874c2838ed823ce914?s=96&d=mm&r=g","caption":"Beatriz Romera"},"logo":{"@id":"https:\/\/secure.gravatar.com\/avatar\/46cc1207f6b15884a3edc270b3dfa4a004849f199e7253874c2838ed823ce914?s=96&d=mm&r=g"},"sameAs":["www.linkedin.com\/in\/bromera","https:\/\/youtube.com\/@datissima?si=y2zjW3d7mbH2YgPF"],"url":"https:\/\/datissima.tech\/ca\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/datissima.tech\/ca\/wp-json\/wp\/v2\/posts\/4023","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/datissima.tech\/ca\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datissima.tech\/ca\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datissima.tech\/ca\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/datissima.tech\/ca\/wp-json\/wp\/v2\/comments?post=4023"}],"version-history":[{"count":7,"href":"https:\/\/datissima.tech\/ca\/wp-json\/wp\/v2\/posts\/4023\/revisions"}],"predecessor-version":[{"id":4030,"href":"https:\/\/datissima.tech\/ca\/wp-json\/wp\/v2\/posts\/4023\/revisions\/4030"}],"wp:attachment":[{"href":"https:\/\/datissima.tech\/ca\/wp-json\/wp\/v2\/media?parent=4023"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datissima.tech\/ca\/wp-json\/wp\/v2\/categories?post=4023"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datissima.tech\/ca\/wp-json\/wp\/v2\/tags?post=4023"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}