Matching ID name with Storyboard Image

[Ballistic P]

Long time listener, first time caller... Blow is a description of how we use the database, and the additional function I am hoping to have while using the "image:Images/*.jpg" Formula.

USE:

We are a 3D production house in the middle of developing a video and at the moment all of the artist open up the "Asset Manager Database" to see what shot number they have been assigned and then go to another directory to open up the corresponding storyboards image to see how the shot needs to be animated, lit, etc. (this waists a little time because each person needs to open up 2 different things to look at for a single shot)

What I would like is to have the Shot ID and the Storyboard match within the database itself.

NEED:

How I have it broken down now is that each shot number was imported from an Excel file and is listed under a static Field, which changes from shot to shot as someone hits the next button (e.g. Page 1= Shot AA_001, Page 2= AA_002, Page 3= AA_002_B, etc). What everyone here has to do now is to open up a separate directory and locate the corresponding storyboards to see what needs to take place in their assigned shot. What I would like to do is to incorporate the shot matching image of each board within the database pages themselves which changes as the Shot name changes. Is there a way to pull the matching image which reflects the static shot number at the top of the page? (example: If I go to page 27 I see shot AB_011_G posted as the header, I would like to have Storyboard AB_011_G.jpg showing to the right so they can reference it, so on and so on with each shot and matching .jpg)

Any help is greatly appreciated. Hopefully I have made sense here.

Ballistic

p.s. You might see my this message under another posting as well, sorry for the confusion. [color:"blue"]

[transpower]

You can have a container field for the Storyboard. Apparently you want to be able to change the ShotID and automatically change the container. But if the ShotID is static, wouldn't the Storyboard also be static? So then it's just a matter of entering the ShotID and the Storyboard manually for each record of the database. On the otherhand, if you store a link to a file name and you change what's in that file name, then you can have a degree of dynamism here, but I doubt that's what you really want. Finally, you can set up a script which can insert an object or picture, either preset or selected at runtime.

[Ballistic P]

Ah, sorry, need to correct this. Actually, the Shot names ARE Dynamic, not static, so when the shot name changes it needs to find the accompanying storyboard image to show. (sorry for the mix-up, meant one thing and typed another)