CDML Link and Portals

[ibiubu]

Here is one that I quite dont know where to begin on an approach.

My current database uses a web page that the user types in their find criteria, and after they submit it they are directed to a different web page that contains CDML tags with thinks to each record that matched their search. They can choose one of those records, and then they go to a new web page containing the CDML tags for all th information I want them to see for that record.

All this is easy enough, but from this point I am not quite sure how to proceed. The cureent web page showing the current record includes a portal. I am able to show the information in the portal along with the rest of the information in the record with my CDML tags. But what I would like to do is have one of the fields in the portal be an active link, so when they click on it, they go to a new web page which contains my CDML displaying the information from the related record.

Creating the new web page with the corect CDML to show the information from the related record is easy enough, I am just not sure how to go about making the field from my portal be an active link that carries the user to the related record and shows the correct information from the related record.

Since I dont even have a clue on this one...I hope I m phrasing the question correctly. This goes a bit beyond my knowledge of CDML.

LR

[dmartens]

check out the FMP-Link tag. You can use this to strip out parts of the url that created the page your portal is on. Or you can just hard code the -find url with in your portal tag.

You will need some kind of unique identifier for each record in the related file. This can be a calculation field using the Status (CurrentRecordID) function. In this case your find criteria would be "&-RecID=[FMP-Field: RelatedRecord::RecID].

[ibiubu]

I am not quite sure I understand it.

With my current configuration I would do a find on my web page, the find brings up the matching page. That web page contains the CDML that shows my portal field. The portal CDML is configured thus:

[FMP-Portal:Budgets]

<span class="text">

<a href="[FMP-linkrecid: layout=Budgets, Format=budgets.htm]">

[FMP-field:Budgets::inty]</a></span>

[/FMP-Portal]

1) The above CDML shows the portal line item field (inty) from the related record.

2) It also makes the line item from the portal a clickable link.

3) It directs that link to my new html page (budgets.html) that will contain all the CDML tags to show the data from the related database file.

4) It also shows what layout in the related file to use.

What it doesn't do is

1) Indicate what the related database file is that the new web page (budgets.html) draws the data from.

2) Indicate what specific related record to pull the data from (my relationship between the 2 databases is based on a field named "Job #").

I am not quite sure how to include these 2 pieces of critical data in the link to make the budgets.html page show the data from the correct record in the related database.

LR

[Jeff Spall]

Hi, here's a portal from one of our pages which illustrates dmarten's answer:

<P>[FMP-PORTAL: relationship]

<TABLE BORDER=0 CELLSPACING=0 WIDTH=322 HEIGHT=72>

<TR>

<TD>

<P><IMG SRC="[FMP-Field: relationship::picturepath]" ALIGN=top></P>

</TD>

<TD WIDTH=5>

<P><IMG SRC="images/lineshimh.gif" WIDTH=3 HEIGHT=1 ALIGN=bottom></P>

</TD>

<TD>

<P><A HREF="http://www.mydomain.com/FMPro?-db=related_database&-format=record_detail.htm&-error=search_error.htm&-lay=layout1&-op=eq&recordkey=[FMP-field:relationship::recordkey]&-find"><B>[FMP-FIELD: relationship::title]</A><BR>

</B>[FMP-FIELD: relationship::description]</P>

</TD>

</TR>

</TABLE>

[/FMP-PORTAL]</P>

basically, you just write a 'find' to the related database and use filemaker fields to complete the find request. here I have a serial number field 'recordkey' as the unique find.

If you don't want to lose the original page and portal whilst you show the details, either get the record detail to open in a little java window or try this:

show the record detail on your results page at one side, but also have an inline action to your original find with the original portal format.

regards, jeff