Yes you can use the longer name on a different layout. For a given Media record you could display Media::LongName or Media::ShortName or both. As long as the relationship keys are set up to display the proper record, you can display whatever fields from that record pretty much however you want on a layout.
I'm sorry if I missed something, but how would I do that?
If you associate a Media record with a Episode record, you can display fields from the Media record on the Episode layout and vice versa. Which fields you display, longname or short name, are up to you
To expand on that, when you use the field tool to add a field to your episodes layout, you can select the Media table in the table drop down and then add fields from the related Media table to your layout just as though there part of the Episode record. The relationship you define will control what data from the Media table will appear with each Episodes record on the layout.
Okay, now I see why I am having difficulty understanding I did not give a full accounting of my data. I also have a child of the Media table named Media_Types which has all the assorted media types. The long and short names are on this table. Have I overcomplicated this by adding the Media_Types table? Should the Media_Types table be a child of the Media Table or should they be joined via a join table?
Sorry about the oversight.
You'll need to spell out the relationships between each of these three tables. I sort of remember what you did from previous posts here, but can't be sure that I am remembering correctly so don't assume any knowledge on our part not posted somewhere in this thread.
Okay My model is as such: (all relationships are done via PK-FK)
The main table is a SHOW table. This table relates to a child table named EPISODE as naturally each show can have multiple episodes.
The EPISODE table relates to a child table name MEDIA. This is to account for the different iterations of media housed for each episode. For example, an episode can have a DVD and a Tape and a Film at once.
The MEDIA table relates to a child table named MEDIA_TYPES which is where all the media info is stored. It has a number of types which in some cases can be quite detailed and long. I made this a separate table so that when a new format is added as usually happens every 3 years or so you can simply add a new MEDIA_TYPES record and not have to repopulate all the Value lists that correspond. Due to the length of the names of these media types, I have created two separate fields. The first displays the full name and type (i.e. SONY HDCAM SR MASTER) while the second contains an abbreviated version (i.e HDCAM SR M).
So thus, on a tracker layout that is showing records from the EPISODE table, media can be added via a portal on that layout that shows records from the MEDIA table. The name of the media is a field on the MEDIA table. This name is populated via a dropdown value list that draws the values from the full name on the MEDIA_TYPES however displays the abbreviated name.
However, I also have a layout showing records from the MEDIA table where the individual records for each episode's media can be viewed. I would like however for the media name shown here to be the full name and not the abbreviated name. I am not sure how to go about doing that. Since whenever I change the name here to the full name it changes it on the EPISODE layout. I hope that is clearer.
Show---<Episode----<Media>-------MediaTypes (---< means one to many)
If I have that correct, you can add fields from MediaTypes to the portal row of your Media Portal on the Episode layout. This can include the long name you describe. You can place it next to your drop down list or you can use behavior settings to deny access to the field and put it on top of your drop down list so that it is not visible. (Give the long name field an opaque field color to keep the drop down field's data hidden.)
When the user clicks on this field, the drop down list behind it deploys. When you exit the value list, it disappears behind the long name field and you see the long name for the selected media type.