AnsweredAssumed Answered

Packing Matrices

Question asked by DanielPerry on Feb 24, 2015
Latest reply on Mar 3, 2015 by DanielPerry

Title

Packing Matrices

Post

I fear I may be biting off more than I can chew with this one. And I'm only looking for a nudge in the right direction, useful suggestions on this project, rather than someone to walk me through this. 

I have 2 tables, one is a list of sites, one is a list of printed items. Both tables have data tagged against each site, or each printed item. Stating if the site serves a particular type of coffee, operates at a particular price band, has a particular style of print design, etc etc. 

So each printed item is valid for a different cross section of sites. I think this makes sense?

Using this I would normally create a very large packing matrix as a spreadsheet (so when printers produce the packs, each site gets the relevant printed items). I'm wondering if I can use filmmaker to cross reference the 2 tables, and automatically produce the packing matrix?

It seemed like a simple idea until I started trying to execute it.

Outcomes