Subject: | |
From: | |
Reply To: | |
Date: | Sat, 11 Jun 2011 16:40:31 +1000 |
Content-Type: | text/plain |
Parts/Attachments: |
|
|
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
|
|
|