AnsweredAssumed Answered

Different Calculations for each Vendor (record)

Question asked by liontv on Apr 3, 2013
Latest reply on Apr 3, 2013 by philmodjunk

Title

Different Calculations for each Vendor (record)

Post

     Hello

     I am building my first database so bear with me here.  

     I am trying to build a cost estimater for a video editing project I am working on.  Currently I am working with two tables, Clips and Vendors.  I have been able to sucessfully get data on each clip in by exporting a edl file from my editing software and importing it into the clips table.  From the file names of the clips I can determin which vendor it came from and through a relationship I can track which clips came from each.  Also from the in and out times generated from the edl I can determin how long each clip is. So far this is working great and I can see how many total clips or seconds of clips are being used from any single vendor.   

     My problem comes when I try to apply a formula that will multiply out my cost.  Each vendor has a different set of variables to multiply by so I can't make one formula that fits them all.  Instead I need to have a seprate formula for each and store that in the vendors record so it can be used to multiply out the final cost.  

     I guess my question is if there is a way to store a record specific formula as opposed to programing one that would effect the whole table?

     I have tried to store the formula as text in a text field but when I create a calculation field to pull it into I can't recognize it as a calculation just as text.  

     Is this the correct way to go about it?  Any help would be appriciated.  

Outcomes