Portal Link using composite key

[Iainmck]

I have 3 tables.....

1) Companies (Details of company)

2) Services (Services offered by all companies)

3) Company_Services (linking table to resolve the many to many relationship between tables 1 & 2 and comprising only of company_ID & service_Code).

I have an HTMl page which shows an individual company with a portal showing each service_Code offered by that company and want to create a hyperlink to another page which will detail a description of the service (held in table 2). Creating such a link from a portal would normally involve referencing a related field name which uniquely identifies the row to be displayed form table 3 upon clicking the hyperlink however as table 3 has no such individual field is it possible to quote more than one field (i.e. the composite primary key).

NB: using only the compnay_ID as shown in the code below produces the same result upon clicking hyperlink for all portal links i.e. the ID to be found doesn't change.

<a href="FMPro/_DB=Company_Services.fp5&-lay=web&-format=CS_detail.html&company_ID=[FMP-Field:CSP::company_ID]&-Find

Hopefully I've explained sufficiently without waffling too much.

[xtrim]

Hi

If I understand what you need :

You have :

Id Field1 Field2

1 aaaaaa bbbbbb

2 bbbbbb aaaaaa

You want to be able to click on the "ID" field and then to display the detail of that ID.

I did it with a self-join relationship.

I Have a global field [g_company_id] and I relate it to [company_id]

Try :

<a href="FMPro/_DB=Company_Services.fp5&-lay=web&-format=CS_detail.html&g_company_ID=[FMP-Field:CSP::company_ID]&-Edit

This will insert the "ID" you clicked on to the g_Company_id field and then you can just need to format the details page to display the relationship's fields to view the details of that ID and even edit them...

Hope this helps....