I have a supplier that has been given a rang of number for her inventory. I am trying to auto populate a text field called Supplier with there name based on the inventory number assigned to the item. I have tried using a text field and a calculation field using an if statements and even a Case statement. No luck! =( I seem to always get ether all the numbers assigned to one supplier or some of the numbers are right but then other lower digit numbers are wrong. She is has a rang of 100,000 - 299,999 for her inventory. My inventory runs from 21 - 99,999. So any number that is assigned to her rage will get her store name and vise versa for mine. Any one have any thoughts? Thanks for taking the time to read this.