Hello,

I am using FileMaker Pro 5.5 the last three months.

I have an Excel express sheet into a workbook with 2 columns that I wan
to link into a layout.
How I can link those columns with the layout in FM?

Thanks for you collaboration.

It does not work that way - I think -.
If you have a regular Excel file - I don't know what is "an Excel express
sheet into a workbook" -, with 2 columns - let's name them 'Col1' and
'Col2', that could be the first line of that Excel sheet - and 'n' lines,
you should 'import' those data, probably into a new 'ExcelData.fp5' file,
in which you had created (at least) 2 fields 'Col1' and 'Col2' with the top
menu 'File' / 'Import Record' / 'File', View by 'Matching Names'. This will
create as many records as there are lines in the Excel file. Now in that
'ExcelData.fp5' file, you should make a field 'ID', that could be matched
with the 'ID' of your other FMP file in which you first create a
relationship with the 'ExcelData.fp5' file via the matching link 'ID', and
then create a portal from that relationship. In that portal, you show the
related 2 fields 'Col1' and 'Col2'.
If you want to see ALL those n records, then set ID (calc) = 1 in both fp5
files.
I guess you have pretty many things to learn ...
Remi-Noel


"Darwin" <darwin (AT) gsiskylights (DOT) com> a écrit dans le message de news:
1165421002.305022.283460 (AT) j72g20...oglegroups.com...