portal not working
I have two excel files that I have imported into FMP rel 11. one of them consists of author,title, status information. the other contains multiple records for each title. I am trying to construct a portal that will allow me to display several fields for each repeating record when I use the layout for the first file. I have created a relationship between the two tables using the title field of the first and what I'll call the subject for the second. this is a one to many relationship. I have created the portal on the layout for the first file. But, no fields from the second file are displayed for any of the records in the first file. I have re-done the construction several times, checking everything, and cannot see anything wrong. I would appreciate any suggestions on what I may be doing wrong.
The only two weird things about these files I can think of are one, that they are imported excel worksheets, originating from different sources, and two, that the second file, the one with many records for each occurrence in the first file, also has numerous records that do not match up with any of the records in the first file.