First check to make sure that "shot vfx number" has the same data type defined in both fields of the two tables.
Second, make sure that the fields actually contain data that exactly match each other for a given pair of records that should be linked to each other.
Yes, both of those match up competely. I have a "TEST" record for this purpose.
It must be something in the way I'm linking them that I just don't know about. The container fields don't know to look to each other across databases. Is there something in conditional formatting like a formula that would let the fields know to look to each other?
Also, just to make sure you know what I'm trying to do. I want the main database container field to automatically be populated with the container value in the alternate database. So once the alternate database container field is populated with an image, I want the image to show up in the container field of the main database.
Ok, I think I see the problem. A field in one table will not magically display the data from a related table simply because they are linked in a relationship.
You do not need container fields in both tables. Instead, remove one of these fields from one of these tables. Then, on the layouts where you used to have the container field that you just removed, add the container field from the related table where you retained this container field.
Note, if one table shows all the images and the other table has empty container fields, delete the container field from the table where they are empty.
It totally makes sense in theory (sorry I"m just not getting some part of it for some reason). So now my problem is that since the container field in the alternate database is not a local table it isn't an option to add as a field. The table shows up in my relationships section but because I"ve added it as an external source.
So how would I go about bringing in the external field as a local field?
If you have added a table occurrence reference to this external table as you must have done in order to show the relationship dialog that you posted, then you should be able to add this field to the layout just as though it were from a table defined in your current file. I suggest checking to see what you have set up in Manage | database | relationships and how it relates to the table occurrence you have specified in Layout Setup... for your layout where you are trying to add this field.
Thank you so much. I got it to work.