I'd go back to Steve's post and take another look. You replied that the fields were drawn from the proper table, but are they drawn from the proper TO? What you describe is commonly the result of using the wrong TO. 'Wrong' means a different TO than the portal's (direct inline hops from the portal's TO are OK).
John Weinshel Datagrace Vashon Island, WA (206) 463-1634 Member, FileMaker Business Alliance Certified For FileMaker 10 ________________________________________ From: FileMaker Pro Discussions [mailto:[email protected]] On Behalf Of Peter Kilcoyne Sent: Wednesday, October 07, 2009 12:47 PM To: [email protected] Subject: Re: Relationship Issue Neither field is calculated, both are text fields one with a drop down list yes/no and one with an auto enter "No". Both are within the borders of the portal. I suspect, but can't figure it out, is that it has to do with the relationship and how it is set up. But what is stumping me is why the Mail Portal list the same record 9 times instead of individual records. Peter On Oct 7, 2009, at 3:46 PM, Richard S. Russell wrote: On 2009 Oct 7, at 14:37, Peter Kilcoyne wrote: Thanks Steve, I do have the fields from the proper Table in the proper portal. Enjoy the wine. Another problem similar to what Steve mentioned can arise if you're displaying a calculated field. If that's the case, go back to the definition of that field and look at the very topmost line in the calculation dialog box, where it says "Evaluate the calculation from the context of:" and make sure you're eyeballing it from the proper table. Then there's the ridiculously prosaic question of whether the field is physically within the borders of the portal's top line.
