I have many to many tables with a twist that has me stuck:
Items table<->bridge table<->photos table
If I only have one photo the inline items show as needed… however if I have multiple versions of the photos I can’t determin how to link up properly, right now only one of the rows for the photo return the inline view.
We name the versions with suffix like _0001, _0002.
The version names do not exist in my Bridge Table as they are created throughout the day, is there a way to generate them in the bridge with the associated items of the original photo?
OR is there a formula solution to create a custom inline ref view of items based on the original photo name?
My photo version name is the current key for the photo table, as it is unique, the original photo name is no longer unique due to versions of photos but both columns exist, one for photo ID and one for photo version ID. I feel like this is doable, yet over my head.