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;
Field 2 Picture
Has 50 records (ID 1-50)
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;
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.