How can I lookup a summary field from an external file in FileMaker Pro?
Any advice would be appreciated.
Summary fields in FMP2.1 can not be used in a lookup situation as the
summary field is a "group" of records, not just one.
What you can do is sort the report (tick the include summary fields and
include the target summary field in the sort) and then export the info to
a text file.
From their you can import the data into your target file.
If one does this on a regular basis, you can script the procedure.
Don R McCamey, BSBA AFAMI
MasterWare, Sydney Australia
> Any advice would be appreciated.
I had the same delema but lost only replacable stuff. Went from MAC FMP 2.0 at
one job to PC FMP 3.0. Didn't recover any thing.
However I didn't think about exporting to yet another program.
If FMP 2.0 can export to excel try that and then try importing the excel file.