I just started using filemaker pro 11 and I am trying to improve my companys database and I am not sure if what I want to do is possible or if I just dont know the right thing to do. I did some browsing and I think it is possible, there is just so much information that I am not sure if I found the right information...
So we are a design company and we have over 10k job numbers for past jobs. All formated the same for the most part "ABC - 12345" and so on, we are switching over to just using a numaric job number but we need to be able to search all the old jobs. So is there a way to have a field only display the number part of the old jobs and be able to display the new jobs as well?
Thanks any help is much apreaceated,