Dear FM Geeks.

Please could you help me with the best way forward to the following CDML Html questions. Some history, database1 displays a related field (through User ID relationship)from database2 in a html file.

1) I want o be to able to edit a related record in database2 from database1. through User ID relationship.

2) How do I just view the related record in database2 from database1, through relationship user ID.

3) How can I created a related record to database2 from database1, through relationship user ID.

I do have some experience of using CDML, but I want to hear other opinions.

Please submit some example code. I am very greatful for any help. :D

Hi, recomm! I dunno whether or not folks on FMFORUMS take pride in your greeting, but until someone speaks up, here's what I think I understand about situtations like yours...

You can display related information with CDML using the [FMP-portal] tag as described in the CDML reference db and it will allow you to show related fields just like a regular portal in FM client, but I don't think CDML can create related records, per se, though you can certainly create records (or edit them) individually.

Here's the example from the CDML reference db...

Syntax example(s)

Display a portal using an HTML file

[FMP-Portal: InvoiceID]

[FMP-Field: InvoiceID::Product Name] - [FMP-Field: InvoiceID::Product Count]

[/FMP-Portal]

You can Edit related records a couple of ways. One is to use a Portal and the other is to use [FMP-InlineAction] tags.

Using a Portal you can do this:

[FMP-Portal:work_periods]

Line ID:

Text:

[/FMP-Portal]

New Line ID:

New Text:

All the best.

Garry