Problem using a Portal on a Webpage?

[Zowsky]

I have all my pages in the web folder.

and when I run the search page, it says database is not open, but I have it open? here is my html code:

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

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

<input type="hidden" name="-lay" value="Layout #1">

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

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

[FMP-Portal: relationship]

<tr>

<td>[FMP-Field: Title]</td>

<td>[FMP-Field: Author]</td>

<td>[FMP-Field: Genre]</td>

<td><a href="[FMP-linkrecid: layout=Browse Books Layout, Format=details.html]">Details</a></td>

</tr>

[/FMP-Portal]

</form>

that is my result page

and here is my search button:

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

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

<input type="hidden" name="-lay" value="Layout #1">

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

<center>

<input name="-find" type="submit" value="Show All Books">

<input type="text" name="relationship" value="1">

</center>

<hr>

</form>

But it keeps telling me portal.fp5 isn't open, which is the name of one of my DB's

[Zowsky]

I have all my pages in the web folder.

and when I run the search page, it says database is not open, but I have it open? here is my html code:

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

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

<input type="hidden" name="-lay" value="Layout #1">

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

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

[FMP-Portal: relationship]

<tr>

<td>[FMP-Field: Title]</td>

<td>[FMP-Field: Author]</td>

<td>[FMP-Field: Genre]</td>

<td><a href="[FMP-linkrecid: layout=Browse Books Layout, Format=details.html]">Details</a></td>

</tr>

[/FMP-Portal]

</form>

that is my result page

and here is my search button:

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

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

<input type="hidden" name="-lay" value="Layout #1">

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

<center>

<input name="-find" type="submit" value="Show All Books">

<input type="text" name="relationship" value="1">

</center>

<hr>

</form>

But it keeps telling me portal.fp5 isn't open, which is the name of one of my DB's

[Zowsky]

I have all my pages in the web folder.

and when I run the search page, it says database is not open, but I have it open? here is my html code:

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

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

<input type="hidden" name="-lay" value="Layout #1">

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

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

[FMP-Portal: relationship]

<tr>

<td>[FMP-Field: Title]</td>

<td>[FMP-Field: Author]</td>

<td>[FMP-Field: Genre]</td>

<td><a href="[FMP-linkrecid: layout=Browse Books Layout, Format=details.html]">Details</a></td>

</tr>

[/FMP-Portal]

</form>

that is my result page

and here is my search button:

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

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

<input type="hidden" name="-lay" value="Layout #1">

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

<center>

<input name="-find" type="submit" value="Show All Books">

<input type="text" name="relationship" value="1">

</center>

<hr>

</form>

But it keeps telling me portal.fp5 isn't open, which is the name of one of my DB's

[andygaunt]

Hi Zowsky -

To start with your fields in the portal must be referencing the relationship (eg - >[FMP-Field:relationship::Title].

However, this looks like you are trying to return a list of books that the user then clicks on to see detail for a particular book.

For this, you do not need a form on the result page, nor a portal.

Try using a record command to show the found records

Wrap an [FMP-Record] around your table row

[FMP-Record]

<tr>

<td>[FMP-Field: Title]</td>

<td>[FMP-Field: Author]</td>

<td>[FMP-Field: Genre]</td>

<td><a href="FMPro?-db=portal.fp5&-lay=Layout#1&-format=details.html&-RecID=[FMP-CurrentRecID]&-Find">Details</a><td>

</tr>

[/FMP-Record]

[andygaunt]

Hi Zowsky -

To start with your fields in the portal must be referencing the relationship (eg - >[FMP-Field:relationship::Title].

However, this looks like you are trying to return a list of books that the user then clicks on to see detail for a particular book.

For this, you do not need a form on the result page, nor a portal.

Try using a record command to show the found records

Wrap an [FMP-Record] around your table row

[FMP-Record]

<tr>

<td>[FMP-Field: Title]</td>

<td>[FMP-Field: Author]</td>

<td>[FMP-Field: Genre]</td>

<td><a href="FMPro?-db=portal.fp5&-lay=Layout#1&-format=details.html&-RecID=[FMP-CurrentRecID]&-Find">Details</a><td>

</tr>

[/FMP-Record]

[andygaunt]

Hi Zowsky -

To start with your fields in the portal must be referencing the relationship (eg - >[FMP-Field:relationship::Title].

However, this looks like you are trying to return a list of books that the user then clicks on to see detail for a particular book.

For this, you do not need a form on the result page, nor a portal.

Try using a record command to show the found records

Wrap an [FMP-Record] around your table row

[FMP-Record]

<tr>

<td>[FMP-Field: Title]</td>

<td>[FMP-Field: Author]</td>

<td>[FMP-Field: Genre]</td>

<td><a href="FMPro?-db=portal.fp5&-lay=Layout#1&-format=details.html&-RecID=[FMP-CurrentRecID]&-Find">Details</a><td>

</tr>

[/FMP-Record]