{"id":685,"date":"2011-04-05T09:31:04","date_gmt":"2011-04-05T09:31:04","guid":{"rendered":"https:\/\/gofilemaker.de\/?p=685"},"modified":"2022-03-29T07:33:46","modified_gmt":"2022-03-29T06:33:46","slug":"1n-vztahy-priklad-zakaznici-a-clanky","status":"publish","type":"post","link":"https:\/\/gofilemaker.de\/cs\/2011\/04\/1n-vztahy-priklad-zakaznici-a-clanky\/","title":{"rendered":"Vztahy 1:n v aplikaci FileMaker Pro na p\u0159\u00edkladu z\u00e1kazn\u00edk\u016f a \u010dl\u00e1nk\u016f"},"content":{"rendered":"<h2>Vybudov\u00e1n\u00ed vztahu<\/h2>\n<p><img decoding=\"async\" class=\"alignleft size-full wp-image-708\" title=\"Vztah 1:1 v aplikaci FileMaker Pro na p\u0159\u00edkladu datab\u00e1ze z\u00e1kazn\u00edk\u016f a \u010dl\u00e1nk\u016f.\" src=\"https:\/\/gofilemaker.de\/wp-content\/uploads\/artikelbild_1n_beziehung_filemaker.jpg\" alt=\"Vztah 1:1 v aplikaci FileMaker Pro na p\u0159\u00edkladu datab\u00e1ze z\u00e1kazn\u00edk\u016f a \u010dl\u00e1nk\u016f.\" width=\"202\" height=\"160\"><\/p>\n<p>Abyste mohli tento vztah nav\u00e1zat, mus\u00edte b\u00fdt bu\u010f v oblasti <a href=\"https:\/\/gofilemaker.de\/cs\/glosar\/tabulka\/\" target=\"_self\" title=\"Co je to tabulka v aplikaci FileMaker? Tabulka se ve FileMakeru pou\u017e\u00edv\u00e1 k...\" class=\"encyclopedia\">Tabulka<\/a> \"Z\u00e1kazn\u00edci\" pole pro \u010d\u00edslo \u010dl\u00e1nku, kter\u00e9 umo\u017e\u0148uje pouze jeden \u010dl\u00e1nek na z\u00e1kazn\u00edka, nebo v tabulce \u010cl\u00e1nky pole pro \u010d\u00edslo z\u00e1kazn\u00edka, kter\u00e9 rovn\u011b\u017e umo\u017e\u0148uje pouze jednoho z\u00e1kazn\u00edka na \u010dl\u00e1nek. Tento typ jedine\u010dn\u00e9ho vztahu (1:1) v\u0161ak nen\u00ed v\u017edy \u017e\u00e1douc\u00ed. Hled\u00e1 se proto mo\u017enost vztahu 1:n, v n\u011bm\u017e z\u00e1kazn\u00edk ukazuje na n\u011bkolik \u010dl\u00e1nk\u016f nebo stejn\u00fd \u010dl\u00e1nek ukazuje na n\u011bkolik z\u00e1kazn\u00edk\u016f. K implementaci tohoto typu vztahu v aplikaci FileMaker Pro je zapot\u0159eb\u00ed dal\u0161\u00edho <a href=\"https:\/\/gofilemaker.de\/cs\/glosar\/referencni-tabulka\/\" target=\"_self\" title=\"Co je to souvisej\u00edc\u00ed tabulka v aplikaci FileMaker? Souvisej\u00edc\u00ed tabulka je...\" class=\"encyclopedia\">Referen\u010dn\u00ed tabulka<\/a>. V tomto \u010dl\u00e1nku popisuji, jak lze takov\u00e9 \u0159e\u0161en\u00ed implementovat v syst\u00e9mu FileMaker.<a href=\"https:\/\/gofilemaker.de\/cs\/glosar\/databaze\/\" target=\"_self\" title=\"Co je to datab\u00e1ze? Datab\u00e1z\u00ed (datab\u00e1zov\u00fdm syst\u00e9mem, DBS) se rozum\u00ed...\" class=\"encyclopedia\">Datab\u00e1ze<\/a> lze realizovat. <!--more Weiterlesen &gt;&gt;&gt;--><\/p>\n<p>Tuto referen\u010dn\u00ed tabulku nazvu \"Polo\u017eka z\u00e1kazn\u00edkovi\". Tato tabulka m\u00e1 zpo\u010d\u00e1tku pouze dv\u011b pole: \"_reCustomers\" a \"_reArticles\", kter\u00e1 spolu souvisej\u00ed podle sch\u00e9matu (obr. 1). Tabulka \"Seznam v\u00fdb\u011bru \u010dl\u00e1nk\u016f\" nen\u00ed dal\u0161\u00ed tabulkou FileMaker Pro, ale pohledem na tabulku \u010cl\u00e1nky, jak je velmi z\u0159eteln\u011b vid\u011bt ve sloupci \"Vzhled ve sch\u00e9matu\" v definici tabulky.<\/p>\n<figure id=\"attachment_686\" aria-describedby=\"caption-attachment-686\" style=\"width: 397px\" class=\"wp-caption alignnone\"><img decoding=\"async\" class=\"size-full wp-image-686\" title=\"Vztah\" src=\"https:\/\/gofilemaker.de\/wp-content\/uploads\/Beziehung.png\" alt=\"Vztahy FileMakeru v diagramu\" width=\"397\" height=\"323\" srcset=\"https:\/\/gofilemaker.de\/wp-content\/uploads\/Beziehung.png 397w, https:\/\/gofilemaker.de\/wp-content\/uploads\/Beziehung-300x244.png 300w\" sizes=\"(max-width: 397px) 100vw, 397px\"><figcaption id=\"caption-attachment-686\" class=\"wp-caption-text\">Obr. 1 Struktura vztah\u016f<\/figcaption><\/figure>\n<p>Pro\u010d pot\u0159ebuji tabulku \"Seznam pro v\u00fdb\u011br polo\u017eek\"? No, tabulka \"Polo\u017eka\" souvis\u00ed s tabulkou \"Polo\u017eka z\u00e1kazn\u00edkovi\" a m\u016f\u017ee b\u00fdt pou\u017eita jako <a href=\"https:\/\/gofilemaker.de\/cs\/glosar\/seznam-hodnot\/\" target=\"_self\" title=\"Co je to seznam hodnot v aplikaci FileMaker? Seznam hodnot je seznam hodnot v...\" class=\"encyclopedia\">Seznam hodnot<\/a> v r\u00e1mci vztahu, ale pot\u0159ebuji seznam hodnot pro v\u00fdb\u011br polo\u017eek, tak\u017ee existuje tabulka \"Seznam v\u00fdb\u011bru polo\u017eek\", kter\u00e1 je datov\u00fdm z\u00e1kladem pro seznam v\u00fdb\u011bru.<\/p>\n<figure id=\"attachment_8342\" aria-describedby=\"caption-attachment-8342\" style=\"width: 468px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/gofilemaker.de\/cs\/filemaker\/skoleni-koucovani\/\"><img decoding=\"async\" class=\"wp-image-8342\" src=\"https:\/\/gofilemaker.de\/wp-content\/uploads\/468x60r_training_coaching.gif\" alt=\"\u0160kolen\u00ed a kou\u010dov\u00e1n\u00ed v aplikaci FileMaker\" width=\"468\" height=\"60\"><\/a><figcaption id=\"caption-attachment-8342\" class=\"wp-caption-text\">Zobrazit<\/figcaption><\/figure>\n<h2>Postoj ke vztah\u016fm<\/h2>\n<figure id=\"attachment_688\" aria-describedby=\"caption-attachment-688\" style=\"width: 633px\" class=\"wp-caption alignnone\"><img decoding=\"async\" class=\"size-full wp-image-688\" title=\"Vztahy se z\u00e1kazn\u00edky\" src=\"https:\/\/gofilemaker.de\/wp-content\/uploads\/Kunden.png\" alt=\"\" width=\"633\" height=\"578\" srcset=\"https:\/\/gofilemaker.de\/wp-content\/uploads\/Kunden.png 633w, https:\/\/gofilemaker.de\/wp-content\/uploads\/Kunden-300x273.png 300w\" sizes=\"(max-width: 633px) 100vw, 633px\"><figcaption id=\"caption-attachment-688\" class=\"wp-caption-text\">Obr.2 Nastaven\u00ed vztahu \"z\u00e1kazn\u00edk : \u010dl\u00e1nek z\u00e1kazn\u00edkovi\"<\/figcaption><\/figure>\n<p>&nbsp;<\/p>\n<figure id=\"attachment_689\" aria-describedby=\"caption-attachment-689\" style=\"width: 633px\" class=\"wp-caption alignnone\"><img decoding=\"async\" class=\"size-full wp-image-689\" title=\"Obr.3 Detail vztahu \u010dl\u00e1nek\" src=\"https:\/\/gofilemaker.de\/wp-content\/uploads\/Artikel.png\" alt=\"Obr.3 Detail vztahu \u010dl\u00e1nek\" width=\"633\" height=\"578\" srcset=\"https:\/\/gofilemaker.de\/wp-content\/uploads\/Artikel.png 633w, https:\/\/gofilemaker.de\/wp-content\/uploads\/Artikel-300x273.png 300w\" sizes=\"(max-width: 633px) 100vw, 633px\"><figcaption id=\"caption-attachment-689\" class=\"wp-caption-text\">Obr.3 Nastaven\u00ed vztahu \"Polo\u017eka : Polo\u017eka z\u00e1kazn\u00edkovi\"<\/figcaption><\/figure>\n<h2>Um\u00edst\u011bn\u00ed jako sekce v rozvr\u017een\u00ed<\/h2>\n<p>Tabulka \"\u010cl\u00e1nky pro z\u00e1kazn\u00edky\" se zobraz\u00ed jako <a href=\"https:\/\/gofilemaker.de\/cs\/glosar\/uryvek\/\" target=\"_self\" title=\"Co je to port\u00e1l v aplikaci FileMaker? Port\u00e1l se ve FileMakeru pou\u017e\u00edv\u00e1 k...\" class=\"encyclopedia\">\u00daryvek<\/a> v rozvr\u017een\u00ed Z\u00e1kazn\u00edk. Do odd\u00edlu jsou vlo\u017eena n\u00e1sleduj\u00edc\u00ed pole.<\/p>\n<ol>\n<li>_reArticle, pole poch\u00e1z\u00ed z tabulky \"Customers to article\" a je referen\u010dn\u00edm polem tabulky k referen\u010dn\u00ed tabulce \"Article\", obsah (\u010dl\u00e1nky) se zad\u00e1v\u00e1 prost\u0159ednictv\u00edm seznamu hodnot jako \"<a href=\"https:\/\/gofilemaker.de\/cs\/glosar\/rozeviraci-seznam\/\" target=\"_self\" title=\"Co je to rozev\u00edrac\u00ed seznam v aplikaci FileMaker? Rozbalovac\u00ed seznam je seznam...\" class=\"encyclopedia\">Seznam Fade-in<\/a>\" vybr\u00e1no.<\/li>\n<li>df_Bezeichnung, pole poch\u00e1z\u00ed z tabulky \"Article\" a je v\u00fdsledkem vztahu.<\/li>\n<li>df_Description, pole poch\u00e1z\u00ed z tabulky \"Article\" a je rovn\u011b\u017e v\u00fdsledkem vztahu.<\/li>\n<\/ol>\n<p>Pro vztah k z\u00e1kazn\u00edkovi nen\u00ed t\u0159eba um\u00edstit \u017e\u00e1dn\u00e9 datov\u00e9 pole, proto\u017ee vztah je definov\u00e1n tak, \u017ee nov\u00e9 datov\u00e9 z\u00e1znamy v sekci automaticky obdr\u017e\u00ed referen\u010dn\u00ed hodnotu a tabulka je um\u00edst\u011bna jako sekce v rozvr\u017een\u00ed Z\u00e1kazn\u00edk, kter\u00e1 v\u017edy poskytuje referen\u010dn\u00ed hodnotu pro aktu\u00e1ln\u00ed datov\u00fd z\u00e1znam. Nastaven\u00ed vztahu viz obr. 2.<\/p>\n<figure id=\"attachment_692\" aria-describedby=\"caption-attachment-692\" style=\"width: 606px\" class=\"wp-caption alignnone\"><img decoding=\"async\" class=\"size-full wp-image-692\" title=\"Zobrazen\u00ed rozvr\u017een\u00ed\" src=\"https:\/\/gofilemaker.de\/wp-content\/uploads\/Layoutansicht.png\" alt=\"Rozlo\u017een\u00ed z\u00e1kazn\u00edka v re\u017eimu rozlo\u017een\u00ed\" width=\"606\" height=\"531\" srcset=\"https:\/\/gofilemaker.de\/wp-content\/uploads\/Layoutansicht.png 606w, https:\/\/gofilemaker.de\/wp-content\/uploads\/Layoutansicht-300x262.png 300w\" sizes=\"(max-width: 606px) 100vw, 606px\"><figcaption id=\"caption-attachment-692\" class=\"wp-caption-text\">Obr. 4 Sekce v uspo\u0159\u00e1d\u00e1n\u00ed z\u00e1kazn\u00edka<\/figcaption><\/figure>\n<h2>Seznam hodnot pro v\u00fdb\u011br \u010dl\u00e1nku<\/h2>\n<p>Struktura seznamu hodnot pro pole _reArticle v sekci \"\u010cl\u00e1nek pro z\u00e1kazn\u00edka\".<\/p>\n<p>Jak ji\u017e bylo zm\u00edn\u011bno, tabulku polo\u017eek nelze pou\u017e\u00edt jako zdroj seznamu hodnot, proto\u017ee je sama sou\u010d\u00e1st\u00ed vztahu, a proto poskytuje hodnoty pouze tehdy, kdy\u017e vztah obsahuje platnou hodnotu. V\u00fdskyt tabulky Item v diagramu pod n\u00e1zvem \"Item selection list\" se proto pou\u017e\u00edv\u00e1 pro seznam hodnot.<\/p>\n<p>Vytvo\u0159en\u00ed nov\u00e9ho seznamu hodnot, panel nab\u00eddek, Soubor, Spravovat, Seznamy hodnot. V zobrazen\u00e9m dialogov\u00e9m okn\u011b klikn\u011bte na tla\u010d\u00edtko \"Nov\u00fd\". Pro uk\u00e1zku postupu p\u0159ikl\u00e1d\u00e1m n\u00e1sleduj\u00edc\u00ed dva sn\u00edmky obrazovky.<\/p>\n<figure id=\"attachment_693\" aria-describedby=\"caption-attachment-693\" style=\"width: 491px\" class=\"wp-caption alignnone\"><img decoding=\"async\" class=\"size-full wp-image-693\" title=\"Seznam hodnot V\u00fdb\u011br \u010dl\u00e1nk\u016f\" src=\"https:\/\/gofilemaker.de\/wp-content\/uploads\/Werteliste_1.png\" alt=\"\" width=\"491\" height=\"403\" srcset=\"https:\/\/gofilemaker.de\/wp-content\/uploads\/Werteliste_1.png 491w, https:\/\/gofilemaker.de\/wp-content\/uploads\/Werteliste_1-300x246.png 300w\" sizes=\"(max-width: 491px) 100vw, 491px\"><figcaption id=\"caption-attachment-693\" class=\"wp-caption-text\">Obr. 5.1 Seznam hodnot pro v\u00fdb\u011br \u010dl\u00e1nk\u016f<\/figcaption><\/figure>\n<p>&nbsp;<\/p>\n<figure id=\"attachment_694\" aria-describedby=\"caption-attachment-694\" style=\"width: 591px\" class=\"wp-caption alignnone\"><img decoding=\"async\" class=\"size-full wp-image-694\" title=\"Seznam hodnot - v\u00fdb\u011br pol\u00ed\" src=\"https:\/\/gofilemaker.de\/wp-content\/uploads\/Wertelsite_2.png\" alt=\"\" width=\"591\" height=\"500\" srcset=\"https:\/\/gofilemaker.de\/wp-content\/uploads\/Wertelsite_2.png 591w, https:\/\/gofilemaker.de\/wp-content\/uploads\/Wertelsite_2-300x253.png 300w\" sizes=\"(max-width: 591px) 100vw, 591px\"><figcaption id=\"caption-attachment-694\" class=\"wp-caption-text\">Obr. 5.2 V\u00fdb\u011br pole pro seznam hodnot<\/figcaption><\/figure>\n<h2>Rozlo\u017een\u00ed v re\u017eimu prohl\u00ed\u017een\u00ed<\/h2>\n<figure id=\"attachment_695\" aria-describedby=\"caption-attachment-695\" style=\"width: 603px\" class=\"wp-caption alignnone\"><img decoding=\"async\" class=\"size-full wp-image-695\" title='Tabulka &quot;\u010cl\u00e1nky pro z\u00e1kazn\u00edky&quot; v rozvr\u017een\u00ed' src=\"https:\/\/gofilemaker.de\/wp-content\/uploads\/Das-Layout.png\" alt=\"\" width=\"603\" height=\"516\" srcset=\"https:\/\/gofilemaker.de\/wp-content\/uploads\/Das-Layout.png 603w, https:\/\/gofilemaker.de\/wp-content\/uploads\/Das-Layout-300x256.png 300w\" sizes=\"(max-width: 603px) 100vw, 603px\"><figcaption id=\"caption-attachment-695\" class=\"wp-caption-text\">Obr. 6 Tabulka \"\u010cl\u00e1nky pro z\u00e1kazn\u00edky\" v rozvr\u017een\u00ed Z\u00e1kazn\u00edci<\/figcaption><\/figure>\n<p>Po vytvo\u0159en\u00ed vztahu lze nyn\u00ed ka\u017ed\u00e9mu z\u00e1kazn\u00edkovi p\u0159i\u0159adit libovoln\u00fd po\u010det \u010dl\u00e1nk\u016f. Tabulka \"Z\u00e1kazn\u00edci k \u010dl\u00e1nku\" rovn\u011b\u017e poskytuje libovoln\u00fd po\u010det z\u00e1kazn\u00edk\u016f pro dan\u00fd \u010dl\u00e1nek.<\/p>\n<p>Jens Liebelt, duben 2011.<\/p>","protected":false},"excerpt":{"rendered":"<p>Beziehung aufbauen Um diese Beziehung aufzubauen, ben\u00f6tigt man entweder in der Tabelle \u201eKunden\u201c ein Feld f\u00fcr die Artikelnummer, was aber nur einen Artikel pro Kunde zul\u00e4sst, oder in der Tabelle Artikel ein Feld f\u00fcr eine Kundennummer, was ebenfalls nur einen Kunden pro Artikel zul\u00e4sst. Diese Art von eindeutigen Beziehungen (1:1) ist aber nicht immer gew\u00fcnscht. [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":32984,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":144,"footnotes":""},"categories":[1,5],"tags":[],"class_list":["post-685","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-filemakerpro","category-tipps-anleitungen"],"_links":{"self":[{"href":"https:\/\/gofilemaker.de\/cs\/wp-json\/wp\/v2\/posts\/685","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/gofilemaker.de\/cs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/gofilemaker.de\/cs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/gofilemaker.de\/cs\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/gofilemaker.de\/cs\/wp-json\/wp\/v2\/comments?post=685"}],"version-history":[{"count":0,"href":"https:\/\/gofilemaker.de\/cs\/wp-json\/wp\/v2\/posts\/685\/revisions"}],"wp:attachment":[{"href":"https:\/\/gofilemaker.de\/cs\/wp-json\/wp\/v2\/media?parent=685"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/gofilemaker.de\/cs\/wp-json\/wp\/v2\/categories?post=685"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/gofilemaker.de\/cs\/wp-json\/wp\/v2\/tags?post=685"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}