AnsweredAssumed Answered

easy one (i hope) TABLE relationships and making records with portal entries read as unique--read on

Question asked by ijontichy on Aug 28, 2009
Latest reply on Aug 28, 2009 by comment_1

Title

easy one (i hope) TABLE relationships and making records with portal entries read as unique--read on

Post

Okay, I'm working on a film and I'm keeping a code book.   This is a record of EVERY SINGLE SHOT captured by the camera.

 

Concurrent with this, VFX staff is keeping a database of just the VFX shots from the film.

 

 

 

Now in MY database, every take is its own record.   77A tk 1, 77A tk 2, 77A tk 3, etc.

 

In THEIR database, each record is a specific SET UP for a shot, but the individual takes are portaled in from another table.   So even though they reference the set up (77A) they are not referencing the take except via a portal. 

 

I can get the set up info to correspond to my set ups, but I'd also like to harvest data they've recorded that's specific to every take.   

 

And while I've tried to use the tables, I'm having no love.    Some suggestions would help this foggy head.   Thanks in advance!

Outcomes