This can be done. I was just working on a similar issue over the week end.
Question: are any of these images linked to more than one product? Might a given image be the primary for one product but not another?
On what table is your layout based when you are adding these images to the portal? Products or some other table?
Sorry I was out of the office most of today...
They are different photos of the same product, not linked or used for another product.
I was able to have the portal (Products layout) add the photos, I have the radio button working, except I can have more than one photo be the primary.
The "1" and "0" is working fine for my export, except I want just one selected image for each product at a time. I verified that in the Image table.
Still trying to figure out how to have the selected photo only show up in a layout for that product without the portal.
"...except I can have more than one photo be the primary."
You want to select more than one photo as the primary for the same product? How do you see that working?
If you just need to select one photo and only one for any given product record, define a field in Products to store the ID of the selected image record. Then you can use that field in a relationship to control which selected image appears on your layout.
You can click a button inside the portal of images to select it. It's script would be a single step:
Set Field [Products::PrimaryImageID ; Images::ImageID]
A calculation field or layout text with a conditional format can use this expression to identify which image in the portal is currently selected as the primary image:
Images::ImageID = Products::PrimaryImageID
I don't want more than one photo as the primary, but the way I have it now, I can.
I will give this a try. I hadn't thought about that work-around.
Thank you for the help with this, but after many hours of research, testing, playing, reading books, this is just way over my pay grade.
I'm just the photographer on the project. Though I've worked with FMP for awhile, nothing has been this complex for me. Maybe it will come to me in my sleep!