I am good with making a table, it's just something I have never had to build, so it's causing hesitation on my end.
Yes, the result is solely based on the two factors (location and work type)
Thanks,
------Original Message------
Matt,
I agree with Don. You can do this by formula, but really this should be table driven so you don't end up with a formula with 100 conditions in a long IF statement. It's just not a good design and it means that regular users can't make a new entry.
If you can describe the parameters which drive the result, we can suggest a table structure. Is the result solely determined by the combination of the Location and Work Type?
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.commark.shnier@gmail.com
------------------------------