i have 5 yearly price books with (pn description price)
i made a query for each year with a search by part number
the results dumps into a table. i then use a report to display the results.
i have one line per year. the problem i have is i need to enter the part number 5 times, once for each query. is there a way to automate this.
i'm a novice at this so keep is as simple as possible
thanks for your help
fred