AnsweredAssumed Answered

Look Up help Please

Question asked by mwilds on Oct 7, 2010
Latest reply on Oct 11, 2010 by mwilds


Look Up help Please


This is my first post ever on a forum so please excuse my ignorance, I haven't worked with filemaker in a while because it has worked flawlessly for years since I built it. But now my company has multiple contracts with different companies and each contract has different prices for the same type of work. In the past we only worked for one company so I built a Invoice file that looked up descriptions & prices from a work file based on a unit number ie. unit 123 = dig ditch 1.00 per ft. and these units are defined by the company's we work for so now I have unit 123 with a different price from each company we work for. So what I was wondering is if there is a way that I can have a different file for each company that holds a description and price , and be able to lookup data from each file based on a unique customer number and a unit number from my Invoice file. I am using FM 5

Thank you,