FMPRO-L Archives

June 2011, Week 2

FMPRO-L@LISTSERV.DARTMOUTH.EDU

Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
Andy Gordon <[log in to unmask]>
Reply To:
FileMaker Pro Discussions <[log in to unmask]>
Date:
Sat, 11 Jun 2011 16:40:31 +1000
Content-Type:
text/plain
Parts/Attachments:
text/plain (24 lines)
In making the jump from FMP 6 to FMP 11, there have been a few 
changes which folks on this list have helped with, thanks for the 
help, much appreciated.

With FMP 6, one could look up records in a number of different source 
files so long as the relationships were in place.

With FMP 11, I am finding that only one source file can be looked-up 
even though there are multiple source files with relationships 
established.  i.e the target file has relationships with 5 other 
source files using the same match field in each.  Each source file is 
for a different years activity but the field names are all the same. 
the match field is an ID field e.g.  2005 sales, match field 05XX, 
2006 sales, match field 06XX etc etc.

When the match field value for any of the source files is entered 
into the target file match field, the values for the looked-up fields 
established in setting up the look up, should be returned.  With FMP 
6, I could enter the match field of any of the source files in a 
relationship with the target file and have the record returned.  Is 
this a 1 to 1  or a 1 to many thing that I don't get?

TIA

ATOM RSS1 RSS2