I cannot for the life of me make this portal work. I have snipped the pertinent tags from the format file and am including here - any help would be greatly appreciated - I cannot tell you how much time I have wasted just trying to get this relationship to work.

The layout in the FMP DB (CGI) does include a portal to the Appointments db and in that portal are the related field and the field I am trying to pull for the web page.

TIA -

-Kele

<form method=post action="FMPro" name="form1">

<input type=hidden name="-edit">

<input type=hidden name="-db" value="Clients.fp5">

<input type=hidden name="-lay" value="CGI">

<input type=hidden name="-format" value="clientdetails.html">

<input type=hidden name="-recid" value="[FMP-CurrentRecID]">

<table border=1 cellpadding=0 cellspacing=2>

<tr>

<td height=21 width=457 valign=top>[FMP-portal:Appointments]

<p>[FMP-field: Appointments::ApptFldDescription, HTML]</p>[/FMP-portal]</td>

</tr>

Version: Developer v6

Platform: Mac OS X Jaguar

Are you getting to this page with a "-find" from a Client listing? For example:

<a href="FMPro?-db=clients.fp5&-format=clientdetails.html&-lay=CGI&-RecID=[FMP-CurrentRecID]&-find">Client [FMP-Field: ClientID]</a>

Or, a search page with a Form? For example:

<form method="post" action="FMPro" name="form1">

<input type="hidden" name="-db" value="Clients.fp5">

<input type="hidden" name="-lay" value="CGI">

<input type="hidden" name="-format" value="clientdetails.html">

Enter ClientID: <input type="text" name="ClientID" value="">

<input type="submit" name="-find" value="Show Client Appointments">

</form>

You will need to use either one of these methods to get to the page containing the Portal for the Portal to work.

Good Luck.

Garry

I guess that is the problem - The first page has a form to initiate the search - the second page provides a list of possible matches using the FM-LINKRECID to go to the details page. So the page preceeding the details page does not perform a find.

I changed the tag and that worked great - thanks!

I'm still confused by this line from your second example

<input type="submit" name="-find" value="Show Client Appointments">

Is the value here anything you want it to be? Does it reference anything other than text? Could it be value="apples and oranges"? What does that value do? Where does it come from or go to?

Thanks for your input - it really is starting to make sense-

-Kele

Version: Developer v6

Platform: Mac OS X Jaguar

Re: <input type="submit" name="-find" value="Show Client Appointments">

The value here is purely for display on the "button".

Instead of using a Portal you can also access the "appointments.fp5" file directly using a find on "ClientID".

All the best.

Garry