{"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":"1iliskilerde-oernek-muesteriler-ve-makaleler","status":"publish","type":"post","link":"https:\/\/gofilemaker.de\/tr\/2011\/04\/1iliskilerde-oernek-muesteriler-ve-makaleler\/","title":{"rendered":"M\u00fc\u015fteriler ve makaleler \u00f6rne\u011fini kullanarak FileMaker Pro'da 1:n ili\u015fkileri"},"content":{"rendered":"<h2>Bir ili\u015fki kurun<\/h2>\n<p><img decoding=\"async\" class=\"alignleft size-full wp-image-708\" title=\"FileMaker Pro&#039;da m\u00fc\u015fteri-makale veritaban\u0131 \u00f6rne\u011fini kullanarak 1:1 ili\u015fkisi.\" src=\"https:\/\/gofilemaker.de\/wp-content\/uploads\/artikelbild_1n_beziehung_filemaker.jpg\" alt=\"FileMaker Pro&#039;da m\u00fc\u015fteri-makale veritaban\u0131 \u00f6rne\u011fini kullanarak 1:1 ili\u015fkisi.\" width=\"202\" height=\"160\"><\/p>\n<p>Bu ili\u015fkiyi kurabilmek i\u00e7in, ya bu ili\u015fkinin i\u00e7inde olman\u0131z ya da <a href=\"https:\/\/gofilemaker.de\/tr\/soezluek\/masa\/\" target=\"_self\" title=\"FileMaker&#039;da tablo nedir? FileMaker&#039;da bir tablo kullan\u0131l\u0131r...\" class=\"encyclopedia\">Tablo<\/a> \"M\u00fc\u015fteriler\", her m\u00fc\u015fteri i\u00e7in yaln\u0131zca bir makaleye izin veren makale numaras\u0131 i\u00e7in bir alan veya Makaleler tablosunda, her makale i\u00e7in yaln\u0131zca bir m\u00fc\u015fteriye izin veren m\u00fc\u015fteri numaras\u0131 i\u00e7in bir alan. Ancak, bu t\u00fcr benzersiz ili\u015fki (1:1) her zaman arzu edilen bir durum de\u011fildir. Bu nedenle, bir m\u00fc\u015fterinin birka\u00e7 makaleye i\u015faret etti\u011fi veya ayn\u0131 makalenin birka\u00e7 m\u00fc\u015fteriye i\u015faret etti\u011fi 1:n ili\u015fkisi i\u00e7in bir olas\u0131l\u0131k aran\u0131r. FileMaker Pro'da bu t\u00fcr bir ili\u015fkiyi uygulamak i\u00e7in ba\u015fka bir ili\u015fkiye ihtiyac\u0131n\u0131z vard\u0131r <a href=\"https:\/\/gofilemaker.de\/tr\/soezluek\/referans-tablosu\/\" target=\"_self\" title=\"FileMaker&#039;da ilgili tablo nedir? \u0130lgili tablo bir...\" class=\"encyclopedia\">Referans tablosu<\/a>. Bu makalede, b\u00f6yle bir \u00e7\u00f6z\u00fcm\u00fcn FileMaker'da nas\u0131l uygulanabilece\u011fini anlat\u0131yorum<a href=\"https:\/\/gofilemaker.de\/tr\/soezluek\/veritabani\/\" target=\"_self\" title=\"Veritaban\u0131 nedir? Bir veritaban\u0131 (veritaban\u0131 sistemi, DBS) \u015fu anlama gelir...\" class=\"encyclopedia\">Veritaban\u0131<\/a> ger\u00e7ekle\u015ftirilebilir. <!--more Weiterlesen &gt;&gt;&gt;--><\/p>\n<p>Bu referans tablosuna \"Item to customer\" ad\u0131n\u0131 verece\u011fim. Bu tablo ba\u015flang\u0131\u00e7ta yaln\u0131zca iki alana sahiptir: \"_reCustomers\" ve \"_reArticles\", bunlar \u015femada g\u00f6sterildi\u011fi gibi ili\u015fkilidir (\u015eekil 1). \"Makale se\u00e7im listesi\" tablosu ba\u015fka bir FileMaker Pro tablosu de\u011fil, tablo tan\u0131m\u0131ndaki \"Diyagramdaki g\u00f6r\u00fcn\u00fcm\" s\u00fctununda \u00e7ok net bir \u015fekilde g\u00f6r\u00fclebilece\u011fi gibi Makaleler tablosunun bir g\u00f6r\u00fcn\u00fcm\u00fcd\u00fcr.<\/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=\"\u0130li\u015fki\" src=\"https:\/\/gofilemaker.de\/wp-content\/uploads\/Beziehung.png\" alt=\"Diyagramdaki FileMaker ili\u015fkileri\" 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\">\u015eekil 1 \u0130li\u015fkilerin yap\u0131s\u0131<\/figcaption><\/figure>\n<p>\"\u00dcr\u00fcn se\u00e7im listesi\" tablosuna neden ihtiyac\u0131m var? \"\u00dcr\u00fcn\" tablosu, \"M\u00fc\u015fteriye \u00fcr\u00fcn\" tablosuyla ili\u015fkilidir ve \u015fu \u015fekilde kullan\u0131labilir <a href=\"https:\/\/gofilemaker.de\/tr\/soezluek\/deger-listesi\/\" target=\"_self\" title=\"FileMaker&#039;da de\u011fer listesi nedir? De\u011fer listesi, i\u00e7indeki de\u011ferlerin bir listesidir...\" class=\"encyclopedia\">De\u011fer listesi<\/a> ili\u015fki i\u00e7inde, ancak \u00f6\u011feleri se\u00e7mek i\u00e7in bir de\u011fer listesine ihtiyac\u0131m var, bu nedenle bir se\u00e7im listesi i\u00e7in veri temeli olan \"\u00d6\u011fe se\u00e7im listesi\" tablosu var.<\/p>\n<figure id=\"attachment_8342\" aria-describedby=\"caption-attachment-8342\" style=\"width: 468px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/gofilemaker.de\/tr\/filemaker\/egitim-koclugu\/\"><img decoding=\"async\" class=\"wp-image-8342\" src=\"https:\/\/gofilemaker.de\/wp-content\/uploads\/468x60r_training_coaching.gif\" alt=\"FileMaker e\u011fitimi ve ko\u00e7lu\u011fu\" width=\"468\" height=\"60\"><\/a><figcaption id=\"caption-attachment-8342\" class=\"wp-caption-text\">Ekran<\/figcaption><\/figure>\n<h2>\u0130li\u015fkiler i\u00e7in tutum<\/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=\"M\u00fc\u015fteri ili\u015fkileri\" 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\">\u015eekil 2 \"m\u00fc\u015fteri : m\u00fc\u015fteriye makale\" ili\u015fkisinin ayarlanmas\u0131<\/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=\"\u015eekil 3 \u0130li\u015fki detay makalesi\" src=\"https:\/\/gofilemaker.de\/wp-content\/uploads\/Artikel.png\" alt=\"\u015eekil 3 \u0130li\u015fki detay makalesi\" 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\">\u015eekil 3 \"Item : Item to customer\" ili\u015fkisinin ayarlanmas\u0131<\/figcaption><\/figure>\n<h2>Yerle\u015fim plan\u0131nda bir b\u00f6l\u00fcm olarak yerle\u015ftirme<\/h2>\n<p>\"M\u00fc\u015fteriler i\u00e7in makaleler\" tablosu \u015fu \u015fekilde g\u00f6r\u00fcnt\u00fclenir <a href=\"https:\/\/gofilemaker.de\/tr\/soezluek\/alinti\/\" target=\"_self\" title=\"FileMaker&#039;da portal nedir? FileMaker&#039;da bir portal kullan\u0131l\u0131r...\" class=\"encyclopedia\">Al\u0131nt\u0131<\/a> M\u00fc\u015fteri d\u00fczeninde. A\u015fa\u011f\u0131daki alanlar b\u00f6l\u00fcme eklenir.<\/p>\n<ol>\n<li>_reArticle, alan \"Customers to article\" tablosundan kaynaklan\u0131r ve tablonun \"Article\" referans tablosuna referans alan\u0131d\u0131r, i\u00e7erikler (makaleler) bir de\u011fer listesi arac\u0131l\u0131\u011f\u0131yla \"<a href=\"https:\/\/gofilemaker.de\/tr\/soezluek\/acilir-liste\/\" target=\"_self\" title=\"FileMaker&#039;da a\u00e7\u0131l\u0131r liste nedir? A\u00e7\u0131l\u0131r liste bir listedir...\" class=\"encyclopedia\">Fade-in listesi<\/a>\" se\u00e7ildi.<\/li>\n<li>df_Bezeichnung, alan \"Article\" tablosundan gelir ve ili\u015fkinin bir sonucudur.<\/li>\n<li>df_Description, alan \"Article\" tablosundan gelir ve ayn\u0131 zamanda ili\u015fkinin bir sonucudur.<\/li>\n<\/ol>\n<p>\u0130li\u015fki, b\u00f6l\u00fcmdeki yeni veri kay\u0131tlar\u0131n\u0131n otomatik olarak referans de\u011ferini alaca\u011f\u0131 \u015fekilde tan\u0131mland\u0131\u011f\u0131ndan ve tablo, ge\u00e7erli veri kayd\u0131 i\u00e7in her zaman referans de\u011ferini sa\u011flayan M\u00fc\u015fteri d\u00fczeninde bir b\u00f6l\u00fcm olarak yerle\u015ftirildi\u011finden, m\u00fc\u015fteriyle ili\u015fki i\u00e7in herhangi bir veri alan\u0131n\u0131n yerle\u015ftirilmesine gerek yoktur. \u0130li\u015fki ayarlar\u0131 i\u00e7in \u015eekil 2'ye bak\u0131n.<\/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=\"Yerle\u015fim g\u00f6r\u00fcn\u00fcm\u00fc\" src=\"https:\/\/gofilemaker.de\/wp-content\/uploads\/Layoutansicht.png\" alt=\"D\u00fczen modunda m\u00fc\u015fteri d\u00fczeni\" 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\">\u015eekil 4 M\u00fc\u015fteri d\u00fczenindeki b\u00f6l\u00fcm<\/figcaption><\/figure>\n<h2>Makale se\u00e7imi i\u00e7in de\u011fer listesi<\/h2>\n<p>\"M\u00fc\u015fteri i\u00e7in makale\" b\u00f6l\u00fcm\u00fcndeki _reArticle alan\u0131 i\u00e7in de\u011fer listesinin yap\u0131s\u0131.<\/p>\n<p>Daha \u00f6nce de belirtildi\u011fi gibi, Item tablosu de\u011fer listesi i\u00e7in bir kaynak olarak kullan\u0131lamaz \u00e7\u00fcnk\u00fc kendisi ili\u015fkinin bir par\u00e7as\u0131d\u0131r ve bu nedenle yaln\u0131zca ili\u015fki ge\u00e7erli bir de\u011fer i\u00e7erdi\u011finde de\u011fer sa\u011flar. Bu nedenle, diyagramda \"\u00d6\u011fe se\u00e7im listesi\" ad\u0131 alt\u0131nda \u00d6\u011fe tablosunun olu\u015fumu de\u011fer listesi i\u00e7in kullan\u0131l\u0131r.<\/p>\n<p>Yeni bir de\u011fer listesi olu\u015fturun, men\u00fc \u00e7ubu\u011fu, Dosya, Y\u00f6net, De\u011fer listeleri. G\u00f6r\u00fcnt\u00fclenen diyalog penceresinde \"Yeni\" d\u00fc\u011fmesine t\u0131klay\u0131n. Nas\u0131l ilerleyece\u011finizi g\u00f6stermek i\u00e7in a\u015fa\u011f\u0131daki iki ekran g\u00f6r\u00fcnt\u00fcs\u00fcn\u00fc ekledim.<\/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=\"De\u011fer listesi Makale se\u00e7imi\" 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\">\u015eekil 5.1 Makale se\u00e7imi i\u00e7in de\u011fer listesi<\/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=\"De\u011fer listesi - alan se\u00e7imi\" 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\">\u015eekil 5.2 De\u011fer listesi i\u00e7in alan se\u00e7imi<\/figcaption><\/figure>\n<h2>G\u00f6z atma modunda d\u00fczen<\/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='D\u00fczendeki &quot;M\u00fc\u015fteriler i\u00e7in makaleler&quot; tablosu' 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\">\u015eekil 6 M\u00fc\u015fteriler d\u00fczenindeki \"M\u00fc\u015fteriler i\u00e7in makaleler\" tablosu<\/figcaption><\/figure>\n<p>Olu\u015fturulan ili\u015fki ile art\u0131k her m\u00fc\u015fteriye istenilen say\u0131da makale atanabilir. \"M\u00fc\u015fterilerden makaleye\" tablosu da bir makale i\u00e7in istenilen say\u0131da m\u00fc\u015fteri sa\u011flar.<\/p>\n<p>Jens Liebelt, Nisan 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\/tr\/wp-json\/wp\/v2\/posts\/685","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/gofilemaker.de\/tr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/gofilemaker.de\/tr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/gofilemaker.de\/tr\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/gofilemaker.de\/tr\/wp-json\/wp\/v2\/comments?post=685"}],"version-history":[{"count":0,"href":"https:\/\/gofilemaker.de\/tr\/wp-json\/wp\/v2\/posts\/685\/revisions"}],"wp:attachment":[{"href":"https:\/\/gofilemaker.de\/tr\/wp-json\/wp\/v2\/media?parent=685"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/gofilemaker.de\/tr\/wp-json\/wp\/v2\/categories?post=685"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/gofilemaker.de\/tr\/wp-json\/wp\/v2\/tags?post=685"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}