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.