Jump to content

Adding new record and related fields

This topic is 8367 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 8367 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.