{"id":9302,"date":"2016-06-29T17:40:00","date_gmt":"2016-06-29T16:40:00","guid":{"rendered":"https:\/\/gofilemaker.de\/?post_type=encyclopedia&#038;p=9302"},"modified":"2022-04-26T11:29:56","modified_gmt":"2022-04-26T10:29:56","slug":"referencni-tabulka","status":"publish","type":"encyclopedia","link":"https:\/\/gofilemaker.de\/cs\/glosar\/referencni-tabulka\/","title":{"rendered":"Referen\u010dn\u00ed tabulka"},"content":{"rendered":"<h2>Co je to souvisej\u00edc\u00ed tabulka v aplikaci FileMaker?<\/h2>\n<p>V datab\u00e1zi je souvisej\u00edc\u00ed tabulka tabulka, kter\u00e1 je spojena s aktu\u00e1ln\u00ed tabulkou prost\u0159ednictv\u00edm ur\u010dit\u00e9ho krit\u00e9ria. Nap\u0159\u00edklad pokud se pr\u00e1v\u011b nach\u00e1z\u00edte v datab\u00e1zi FileMaker, ve kter\u00e9 jsou zobrazeny \u00fadaje o z\u00e1kazn\u00edc\u00edch, tabulky <em>Kontaktn\u00ed osoba<\/em>, <em>Adresy<\/em> nebo <em>Dokumenty<\/em> Referen\u010dn\u00ed tabulky pro hlavn\u00ed tabulku <em>\u00dadaje o z\u00e1kazn\u00edc\u00edch<\/em>.<!--more Weiterlesen &gt;&gt;&gt;--><\/p>\n<p>Souvisej\u00edc\u00ed tabulky lze vz\u00e1jemn\u011b propojit pomoc\u00ed nejr\u016fzn\u011bj\u0161\u00edch krit\u00e9ri\u00ed. Klasick\u00fdm p\u0159\u00edpadem je propojen\u00ed 1:n, kdy je datov\u00fd z\u00e1znam z hlavn\u00ed tabulky propojen s n\u011bkolika datov\u00fdmi z\u00e1znamy ze souvisej\u00edc\u00edch tabulek.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-9303\" src=\"https:\/\/gofilemaker.de\/wp-content\/uploads\/Bezugstabellen-1n-Beziehung.png\" alt=\"Vztah 1:n v aplikaci FileMaker\" width=\"358\" height=\"127\" srcset=\"https:\/\/gofilemaker.de\/wp-content\/uploads\/Bezugstabellen-1n-Beziehung.png 358w, https:\/\/gofilemaker.de\/wp-content\/uploads\/Bezugstabellen-1n-Beziehung-300x106.png 300w, https:\/\/gofilemaker.de\/wp-content\/uploads\/Bezugstabellen-1n-Beziehung-180x64.png 180w\" sizes=\"(max-width: 358px) 100vw, 358px\" \/><\/p>\n<p>Ka\u017ed\u00e1 souvisej\u00edc\u00ed tabulka je propojena s ciz\u00edm kl\u00ed\u010dem _fk_Kunden_ID souvisej\u00edc\u00ed tabulky prost\u0159ednictv\u00edm prim\u00e1rn\u00edho kl\u00ed\u010de (_pk) hlavn\u00ed tabulky. Pokud se ID z\u00e1kazn\u00edka shoduje, datov\u00fd z\u00e1znam v souvisej\u00edc\u00ed tabulce pat\u0159\u00ed vyvolan\u00e9mu z\u00e1kazn\u00edkovi a v souvisej\u00edc\u00ed tabulce m\u016f\u017ee b\u00fdt libovoln\u00fd po\u010det datov\u00fdch z\u00e1znam\u016f se shodn\u00fdmi ID z\u00e1kazn\u00edka.<\/p>\n<p>V datab\u00e1z\u00edch FileMaker lze tabulky propojovat r\u016fzn\u00fdmi zp\u016fsoby. M\u016f\u017eete nap\u0159\u00edklad nastavit, zda se maj\u00ed krit\u00e9ria odkazu shodovat nebo b\u00fdt men\u0161\u00ed (nebo stejn\u00e1) nebo v\u011bt\u0161\u00ed (nebo stejn\u00e1) nebo se nemaj\u00ed shodovat nebo se maj\u00ed shodovat v\u0161echny.<\/p>\n<p>Pokud jsou jako kl\u00ed\u010de hlavn\u00ed tabulky pou\u017eita glob\u00e1ln\u00ed pole, lze v sekc\u00edch \u0159\u00eddit hierarchick\u00e9 struktury \u0159\u00edzen\u00e9 skripty. Pokud u\u017eivatel vybere \u0159\u00e1dek v sekci, skript aktualizuje glob\u00e1ln\u00ed kl\u00ed\u010d pro druhou sekci.<\/p>\n<h2>Dal\u0161\u00ed ot\u00e1zky t\u00fdkaj\u00edc\u00ed se FileMakeru? Osobn\u011b je to rychlej\u0161\u00ed.<\/h2>\n<p>V r\u00e1mci na\u0161\u00ed\u00a0<a href=\"https:\/\/gofilemaker.de\/cs\/filemaker\/skoleni-koucovani\/\"><strong>Kou\u010dov\u00e1n\u00ed a \u0161kolen\u00ed<\/strong><\/a>\u00a0r\u00e1di v\u00e1s osobn\u011b informujeme o funkc\u00edch FileMakeru, kter\u00e9 pot\u0159ebujete pro v\u00fdvoj va\u0161eho \u0159e\u0161en\u00ed FileMaker. Samoz\u0159ejm\u011b r\u00e1di vyhov\u00edme va\u0161im individu\u00e1ln\u00edm po\u017eadavk\u016fm. Fakturace je p\u0159izp\u016fsoben\u00e1 a spravedliv\u00e1 po 15 minut\u00e1ch. Platit m\u016f\u017eete pohodln\u011b bankovn\u00edm p\u0159evodem nebo prost\u0159ednictv\u00edm slu\u017eby PayPal.<\/p>","protected":false},"excerpt":{"rendered":"<p>Co je to souvisej\u00edc\u00ed tabulka v aplikaci FileMaker? Souvisej\u00edc\u00ed tabulka v datab\u00e1zi je tabulka, kter\u00e1 je spojena s aktu\u00e1ln\u00ed tabulkou prost\u0159ednictv\u00edm ur\u010dit\u00e9ho krit\u00e9ria. Nap\u0159\u00edklad pokud se pr\u00e1v\u011b nach\u00e1z\u00edte v datab\u00e1zi FileMaker, ve kter\u00e9 jsou zobrazeny \u00fadaje o z\u00e1kazn\u00edc\u00edch, tabulky Kontaktn\u00ed osoby, Adresy nebo Dokumenty by byly souvisej\u00edc\u00edmi tabulkami k hlavn\u00ed tabulce \u00dadaje o z\u00e1kazn\u00edc\u00edch.<\/p>","protected":false},"author":187,"featured_media":21805,"template":"","class_list":["post-9302","encyclopedia","type-encyclopedia","status-publish","has-post-thumbnail","hentry"],"_links":{"self":[{"href":"https:\/\/gofilemaker.de\/cs\/wp-json\/wp\/v2\/encyclopedia\/9302","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/gofilemaker.de\/cs\/wp-json\/wp\/v2\/encyclopedia"}],"about":[{"href":"https:\/\/gofilemaker.de\/cs\/wp-json\/wp\/v2\/types\/encyclopedia"}],"author":[{"embeddable":true,"href":"https:\/\/gofilemaker.de\/cs\/wp-json\/wp\/v2\/users\/187"}],"version-history":[{"count":0,"href":"https:\/\/gofilemaker.de\/cs\/wp-json\/wp\/v2\/encyclopedia\/9302\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/gofilemaker.de\/cs\/wp-json\/wp\/v2\/media\/21805"}],"wp:attachment":[{"href":"https:\/\/gofilemaker.de\/cs\/wp-json\/wp\/v2\/media?parent=9302"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}