Basic question for my study notes database

[jd9027]

I have a database to manage my study notes/Questions.

I wanted to modify it to make it store multiple images per record in a table. One record in a table should be able to show multiple media files and the same media file may appear in multiple questions. I made a join table to represent this Many2Many relationship.

What kind of field should I make in the layout to add multiple images to a record in the table?

Is this the situation where I use a portal?

[ThatOneGuy]

Hi jd9027:

Yes, this is a perfect candidate for a portal. The beauty of portals (or more correctly, relationships) in FM7 is that we can display a field from table occurrences "anywhere along the relationship path." We couldn't do that in earlier versions.

On your Notes layout, create a portal to show the relationship to your join table. You'll probably want to set the portal options to show a "few" rows and activate the "scroll bar" option. Within the boundaries of the first portal row, add any fields from the join table that you want/need to display.

Here's the twist ... add a Container field for the related Media records based on the table occurrence from the other side of your join table. Not knowing how you've named these TOs, I can't be specific, but look at the "flow" on your Table Occurrence Graph ... in essence, you want to "pull" the Media field from the table occurrence you linked to your join table.

Let us know if this gets you headed in the direction you hoped. If you need more assistance, it might be helpful if you could attach a zipped copy of your file. :goodluck: