I am building an image catalog and I have an image view layout. I also have an artist view layout with artist info a portal to the image table displaying all images by that artist.

The artist information and the Image information are separate tables.

I would like to be able to click on a particular image in the portal in the artist layout, and be taken to the record for that image from the image table in the image layout.

Please advice on how to do this or any alternative ideas.

Thanks

Edited October 7, 200520 yr by Guest

Have a button on the first portal row that performs a script of Going to Related Record. Pick the relationship to your image table and the corresponding layout taht you want ti to go to.

I want to click on a portal row and send some, or all of the data on that portal row to a field on a different layout. Is this possible? - jdawg

Set field [PortalStuff; field1&field2&field3...) Put the button on the portal row.

P.S. Next time do not post on someone else's thread if its not directly related to the thread.

This is called hijacking someone else's thread.

Post a new thread instead.

Good luck.

I apologize. I'm new and learning the right etiquette. Thanks for the tip - jdawg

You can also make the button transparent (arrange on top) and big enough to cover the image and then another button (transparent again) over the other. Attach a script to both (a different script for each if that is what you want to do).

Check out the FileMaker Pro 8 solutions they are giving to the creative community...it's a free download and one of the solutions uses this feature. http://www.filemaker.com/creative

I just want to add that this forum is worth it's weight in gold.

I keep discovering new tricks and especially functionality in script steps I was not previously aware of. This thread pointed me to excatly what I needed to know, and for as long as I have been doing FMP databases I had never used the "go to related record" script step. Instead I had done all this extra scripting to copy and past field information into a "find" request. But when I ran into trying to do that inside of a portal.....Well, you guys who really know what you are doing know that a technique like that would not work.

So, thanks to FMFORUMS I'm back on my way with a new trick in my tool belt.

Thanks again to all of the top notch DB Developers that make this site such an incredibly valuable tool.

Steve