How to open a related record from a CDML portal?

[haret]

Hi

I've used the search but couldn't find a way to do this. I have a "company" database and "employees" database.

Now I have a page that has all the company info I need and below this a portal where all the related employees are listed (from the related "employee" database). I would like to open a new page with the employee info if I click the employee portal row. I haven't found a way to do this (to open the related record). Could someone tell me how this is done?

Thanks in advance !

[haret]

Another question. Is it possible to modify valuelists via CDML? Haven't found a way to do this either...

[Garry Claridge]

One way to "open" a related record is to use a Calculated field (in the related database) which returns the RecordID of each record. This can be used in an anchor <a> tag to find the record in the related database.

If it is a Custom ValueList you may be able to call a Script to modify the ValueList. You would have to make sure that the chance of two or more users attempting to use this Script at the same time is very very low. Another way is to have the ValueList in a "standalone" database, the ValueList can then be created (and modified) in the page with an InlineAction.

Good Luck.

Garry

[haret]

Thanks a lot!

Now I just need to find out how I can display the RecordID in FM used by the web companion. I have a recid field but I haven't figured out the calculation yet... I quess it's google.com time again...

EDIT: Found it... "Status(Currentrecordid)"

Thanks again for your time !