Professional Web Applications Themes

Primary Key - FileMaker

I can make a relation between to files. For example, I define the relation XY with filemaker, and select CustID from file A and CustID from file B. Now I can use in file A the CustTitle from file B, when the relation is true. But, is it possible to specify the relation in the way, that not only one PrimaryKey has to be true, but 2 fields have to be identic. Example: Relation in File A: CustIF from File A = Cust ID from File B AND CustTitle from A = Cust.Title from B....

  1. #1

    Default Primary Key

    I can make a relation between to files. For example, I define the relation
    XY with filemaker, and select CustID from file A and CustID from file B.

    Now I can use in file A the CustTitle from file B, when the relation is
    true.



    But, is it possible to specify the relation in the way, that not only one
    PrimaryKey has to be true, but 2 fields have to be identic.



    Example:



    Relation in File A:

    CustIF from File A = Cust ID from File B AND

    CustTitle from A = Cust.Title from B.








    Javot Guest

  2. #2

    Default Re: Primary Key

    Javot Miller wrote: 

    You could define a calc field in each file, or a text field filled by
    calculation, where the formula is CustID&" "&CustTitle, then use that
    field as the relationship key.

    Bill

    B Guest

  3. #3

    Default Re: Primary Key


    "B Collins" <invalid> schrieb im Newsbeitrag
    news:invalid... [/ref]
    relation [/ref]
    one 
    >
    > You could define a calc field in each file, or a text field filled by
    > calculation, where the formula is CustID&" "&CustTitle, then use that
    > field as the relationship key.
    >
    > Bill
    >[/ref]

    Thank you for this fast and usefull help! Work's fine!


    Javot Guest

Similar Threads

  1. Primary Scratch & Windows Primary Paging file?
    By Tommy Oberst in forum Adobe Photoshop 7, CS, CS2 & CS3
    Replies: 14
    Last Post: April 15th, 10:26 PM
  2. Add primary key
    By Simon Gorski in forum ASP.NET Data Grid Control
    Replies: 0
    Last Post: January 20th, 11:00 PM
  3. Get Primary Key
    By Leon Shaw in forum ASP.NET General
    Replies: 2
    Last Post: July 21st, 12:03 PM
  4. Creation of primary key
    By Anand in forum Microsoft SQL / MS SQL Server
    Replies: 2
    Last Post: July 16th, 03:00 PM
  5. What is the difference with or without ON [PRIMARY]
    By Andreas Klemt in forum Microsoft SQL / MS SQL Server
    Replies: 2
    Last Post: July 11th, 04:23 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139