Adding new record and related fields

[Brulotte]

I'm guessing this is a basic question, I'm just missing how to do it.

I have two databases that are related. The first one has a couple fields then a portal to the other database. (Think of a sales order: Customer Name, Address & Phone in the first database then Quantity, Item Number and Price in the other via a portal.)

How do I set up the CDML tags so that the user can enter Name, Address, Phone then multiple lines of Qty, Item Number and Price?

I'm assuming that proper placement of [FMP-Portal: Line Items] & [/FMP-Portal] has something to do with it. Do I also have to specify a second hidden input for the second database and if so, how does it understand which layout is being used?

I'm sure I'm not the only one wanting to do this. Thanks in advance for the help.

[Anatoli]

There are 10 or more ways how to do it.

What is the problem? Step by step, please.

[Brulotte]

Thought I had. Here are specifics:

It's a news story database

- Two databases: Story.fp5 and Story_details.fp5.

- Story.fp5 has fields: Title, description, owner and a portal (story_details) that pulls from the Story_details.fp5 database. In the portal are fields: Vehicle, vehicle_date, vehicle_status.

- Each story can have multiple Vehicles, vehicle_dates and vehicle_status'.

- I would like to code CDML so that I have an Add page where the user enters title, description, owner, then can enter up to 8 vehicles & their vehicle_dates and vehicle_status'.

- I can easily configure the first three input fields but I can't seem to figure out how to code so the user can enter the multiple portal fields.

I've surrounded those fields with [FMP-Portal] & [/FMP-Portal] but that didn't work. I've tried a couple other things that didn't work. I'm obviously missing something. The CDML examples and templates that come with the CDML tool work only for flat files; not related.

Any help would be greatly appreciated. Thanks.

[Anatoli]

In form 1 you create the Story Record and there will be also unique field with relation to the Story_details db.

On second form you will create records for each Vehicle etc. and you will paste the unique field from Story Record carried to the second form with Token.