To all you database modelers out there I'm hoping to get a little advice. I'm building a new Filemaker database of film elements that have been transferred to various tape formats over the years. So far I have diagramed it with 2 tables - a MediaID table (with attributes such as location, title, etc.,) and a MediaAsset table which describes all the iterations possible for the aforementioned MediaID (Negative, Print,VHS, Beta, DVD, etc.) My question is do I create another table for the timecode or is the timecode an attribute of the MediaID table? Timecode needs to be described both in foot length (35mm negatives and prints are usually described in linear feet) as well as a IN and OUT timecodes for the tape and file based assets. I was hoping to use the TC field to generate a total run times from the in/out TC fields. Any suggestions would be appreciated.