I have a search results page that is formatted as a detail page - ie the search is canned and will find only one record.

On this results page I have 3 portals for relationships as follows;

1. DB1 - DB2

2. DB1 - DB2

3. DB1 - DB3

Relationship 1 and 2 are to the same file but ref different fields. Relationship 3 is to a third database.

The problem I am getting is that, if there is 1 related record for relation ship 1, and 2 for relationship 2, only 1 of the records in relationship 2 will display. In other words, relationship two will only display portal rows for records that relationship 1 has.

I could split Database 2 into 2 databses but would prefer not to. Is there some way around this?

I use similar multiple-relationships between two files. However, I have not had that problem; I may not be using exactly the same conditions.

What does your CDML look like?

All the best.

Garry

Here is the code:

Where;

DB1 = MessageBoard.fp5

DB2 = MB_Items.fp5

DB3 = Schedule.fp5

---------------------------------------------------------------------------------------------

<h3>General Infomation</h3>

<table width="100%" border="0" cellspacing="0" cellpadding="0">

[FMP-Portal: MB_ItemsInfo]

<tr>

<td width="24">&nbsp;</td>

<td width="80">[FMP-Field: MB_ItemsInfo::Date]</td>

<td width="60">[FMP-Field: MB_ItemsInfo::Type]</td>

<td>[FMP-Field: MB_ItemsInfo::DetailsLinkCalc,raw]</td>

<td width="80">[FMP-Field: MB_ItemsInfo::Who]</td>

</tr>

[/FMP-Portal]

</table>

<p>&nbsp;</p>

<hr>

<h3>What's New </h3>

<table width="100%" border="0" cellspacing="0" cellpadding="0">

[FMP-Portal: MB_ItemsInfo]

<tr>

<td width="24">&nbsp;</td>

<td width="80">[FMP-Field: MB_ItemsNew::Date]</td>

<td>[FMP-Field: MB_ItemsNew::DetailsLinkCalc,raw]</td>

<td width="80">[FMP-Field: MB_ItemsNew::Who]</td>

</tr>

[/FMP-Portal]

</table>

<p>&nbsp;</p>

<hr>

<h3>Leave</h3>

<table width="100%" border="0" cellspacing="0" cellpadding="0">

<tr>

<td>[FMP-Portal: Schedule] [FMP-Field: Schedule::Display Away]<br>

[/FMP-Portal]</td>

</tr>

</table>

<hr>

---------------------------------------------------------------------------------------------

Hope you can see what I am doing wrong..

Cheers

Hal.

Hal,

Your second Portal has the wrong name. It has "MB_ItemsInfo", should be "MB_ItemsNew".

Good Luck.

Garry

gee! who feels like a D***head !!

Thanks heaps Garry

Happens to us all! That's why nobody will call you a D***head; except for yourself

All the best.

Garry

Thanks Garry

I appreciate the assistance you always provide!

Cheers

hal