Based on further discussions, the info stored about the media types will be much different than I originally thought, so I'm planning on having a related table for each.
So should I use the zero-width portal trick to hide the non-used tabs (containing the other portals) or should the filtering take place at the Project layout level and have three layouts that each have a different portal included and switch based on Media type?
I hope someone can help or at least point me to a related thread - I haven't been able to get the right search terms to find anything similar.
Thanks in advance!
What do you mean by a "zero width portal"?
I know of a method that uses an invisible tab control and wonder if that isn't what you are thinking of here...
If so, there isn't a clear cut advantage to point to between your two options here. Both have trade offs and you'll have to decide based on exactly how you need to work with these portals and how complex your layout design will be. (the more complex, the less attractive creating and maintaining parallel layouts will be to you...)
Yes the invisible tab control is what I was thinking of. Do you have a suggestion to a thread that has a definitive "How-to" for the invisible tab control? I want to know what I'm getting in for before I make a decision.
I suggest trying it out and seeing how it works for your specific database. Setting up a 2 or three tab invisible tab control is fairly simple, but I haven't made much use of the method so others may have better suggestions.
Create a tab control with the needed tab panels and set them up with your portals.
Use the name box in the inspector's position tab to give each tab panel an object name.
What makes this work is that you use a script with go to object ["tab panel object name here"] to select the tab panel you want to bring to the front.
You'lll need to figure out the best approach to script this. OnlayoutLoad or OnRecordLoad, for example, can run scripts that check a field on the current record to decide which go to object script step to perform to bring the corresponding tab panel to the front.
Once you have this operating successfully, you can make the tab control invisible by selecting a zero width outline or a transparent outline pattern. The tab control's fill color can be set to match the layout's or (I think) a transparent fill color can be specified. That turns your tab control invisible.