Shawn - Thanks so much for clarifying for me. I will proceed with Quick Report.
@ShawnBerk this sounds exactly what I am looking for, I know I have the Part Description as unique in the inventory part in stock table. Can I contact you via email to send you an example of my SQL for you to take a look at?
@Harley - I am probably going to move forward with the Quick Report for this , however I am intrigued by your suggestion to add a Reference Type custom field. We have a table within IFS that now has distinct values for these part numbers but I cannot find where or how to tie to that table from this particular query. Since I am looking in the “Customer Order Lines” table, how do I pull a reference from a field in a different table within IFS? Any help you can give here is greatly appreciated. :-)
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
