AnsweredAssumed Answered

Relationship not working...   why?

Question asked by RaphaelVang on Aug 13, 2015
Latest reply on Aug 13, 2015 by philmodjunk


Relationship not working...   why?



  -  it's quite frustrating, as a longtime FM-user, when you stumble upon a problem that shouldn't be one...  ^^

But, as usual, I just post a quick question here, instead of ripping all of my hair out...

  Hope it's easy;


Table 1



   Field 1

   Field 2 Picture

Has 50 records  (ID 1-50)



Table 2


   Field 10 (Text, Value list )

   Field 11 Picture (container; calculation)

   Field 12  (Text, Value list)

   Field 13 Pircture (container; calculation)



In Table 2, I want to be able to see the picture from Table 1 - by selecting the Fields 10, or 11.

  So; Field 10 selects the value for 11, and 12 for 13.


I have created a relationship by using the “LINK” fields.

  But nothing happens when I try the formula;


Case (

Field 10 = “number 10” ; GetNthRecord (Table 1::Field 2 Picture ; 10);

Field 10 = “Number 4” ; GetNthRecord (Table 1::Field 2 Picture ; 4) )



What am I doing wrong???


I think that I don’t understand the “relationship idea properly…

Since Table 2 doesn’t have 50 records, but just 1 record, I don’t want to use the ID = ID relationship.

  I just want to “grab” information from another Table, by telling FMP10;

  “this is the value; so grab that picture…”

But it doesn’t

  Ah, and I want to do this two times on one layout…   but; that shouldn’t make any difference, I think.