I have been asked to try set up some form of stock control on our comsumables through a query. the only way I could think of it was to have a caterogry with the toners/cartridges in it and I could make a query that will show that catergory in the resolution field. The only issue when making the query is I have to use the "is one of " and add about 50/60 different entries.
Really what i asking is has anyone tried anything like this and and am I right in thinking that I have no choice but to add in the 50/60 items or is there a better way.
any help/ ideas would be great