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