Displaying Multiple Records on one Form

[jbob]

I have a database of all the books I've ever read (dorky I know). I have a table that has all the covers (actual pictures) and the titles. What I would like is a...well I guess a form that displays all the pictures (say 5 rows across and how many ever down) and when you click on them it takes you to that record in the main book list DB.

Can it be done?

Thanks gang!

[DukeS]

Usually you create main form for book entry and insert portal to hold pictures of book in it.

[jbob]

yes I have that on the main book list, but I want to have a "book shelf" which just displays all the covers, and then I can click on one and it takes me to that record in the main book list.

[John Mark Osborne]

Have you tried a relationship using the Cartesian Product operator? Regardless of the key fields used, this relationship operator (x) will display all records from the related table. Once you have all the related records displaying, you can create multiple portals based on this one relationship. Each portal can show as many or as few of the rows from the relationship using the Initial Row and Number of Rows options.

[DukeS]

And if you want to click on the cover that then takes you to the book, create button in portal row and attach GoToRelatedRecord[] script step which takes you to related records on chosen layout.