So the reports table should have a field for ProdType and one for ProdNum. It might look like
RptName |
ProdType |
ProdNum |
report1 |
widget |
UBI123 |
report1b |
widget |
222 |
report1b |
thingy |
985 |
report1c |
thingy |
UBI777 |
Report1b is used for 2 different types, which I presume means different numbers as well. When discerning the in house products, your query would look for those whose first 3 characters begin with UBI by using the Left function.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.