Been banging my head against this wall most of the day, so time to reach out... In simple terms, I have:
Devices - DEV (say a computer)
Accessories - ACC (say a printer)
ACC get assigned to DEV via a join table JDA
I want to indicate if the ACC (in this case printer) is the default ACC for the device, so I have a field in JDA "Default" which is populated with "Yes" via a script if the user selects it as a default device.
I have a portal based on DEV going dev>jda>acc - portal works fine for the name of the ACC etc. But I want to display an icon in the portal if the ACC is default.
So I'm trying to set up a calculated container field such that if in the join, Default = Yes then container field = stored global container field and of course it's shown on the portal.
I've got close with:
dev.JDA_JoinDeviceAccessory::Default = "Yes" ;
but this shows an icon for all instances of the printer on all DEV records. I know I've had to deal with this kind of thing before, but it's been a while and I'm stumped - might be something to do with a List function? Any help appreciated, or if I need to clarify anything, let me know.