Many to One in Individual fields

[OakMan]

It has been a while since I have done FM development.

So I could use some help with HOW to think about this.

I have a table listing products.

I have a second table listing Images for those products.

The key is an item #.

An Item may have several pictures.

Using a portal I can see the list of images for that Item.

That's great BUT I need to put each picture path into a separate field along with the item data to export to an Excel report.

Therefor:

Item # 4, Name "Red Car", Image1 "outside", Image2 "inside", --- and so on.

The number of images varies from 1 to 5 so I need 5 image fields.

I can see them in the portal but how do I get them into individual fields?

If I just export the portal data it puts each image path on a new row.

All help and suggestions greatly appreciated.

I am sure this is do-able I just can't figure out how.

If this is not the correct place to ask this question, please point me in the right direction.

Thanks

Oakley

Edited May 1, 2008 by Guest

[Ugo DI LUCA]

Hi Oakley,

Assuming I understood what you're looking for, a calculation :

Substitute (List ( RelatedImages::Image ) ; "¶" ;";" ) should work

returning all paths separated with a ";"

Edited May 1, 2008 by Guest

[OakMan]

Thank you for your reply.

I tried it but didn't understand how to use it well enough.

I could not get it to work.

I have attached a sample database to help clarify my question.

I think I did the upload correctly but am not sure.

It is a .zip file named PortalTest.fp7.zip

Please take a look and let me know what you think.

Thanks

Oakley

PortalTest.fp7.zip