List of items with no distributor

When I started with RMS, I didn't use the distributor field - big mistake. Now, I have approximately 1,000 items in my DB with no distributor listed. I was wondering if there was a way to figure out what all these items are, and preferably, a mass way of being able to change them to reflect having a distributor.

I have found a few exports that seem to work using the wizards, but simply can't find one that will allow me to see all the items without a distributor.

On top of this, maybe there is a "master" export that literally has every field available for an items. This export would solve my other problem of needed to import items into a new database without copying over quantity (easily editable to 0) or sales info.

Thanks!

Scott Gerhardt Shuffle & Cut Games

Reply to
SubSpirit
Loading thread data ...

Anyone with an idea on this one? (Read: *bump*)

P.S. Distributor = Supplier (figure everyone knows this)

Reply to
SubSpirit

Scott,

SELECT * FROM Item WHERE SupplierID=0

- Evan Culver New West Technologies

Reply to
Evan Culver

So nnce I get this data out (figured out this part, thank you for your help) how do I get it back in post-corrected?

Reply to
SubSpirit

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.