comparing inventory #s from different data bases

[Flanzy]

I have several databases with 30,000 plus items in each. Each database should have matching inventory but they don't. I thought I could create a new data base that could compare the inventory #s from each of the other databases so that the same inventory # would line up across the page, enabling me to see the discrepancies. That didn't really work. I couldn't get the numbers to line up. Can anyone help me - by telling me what I'm not thinking through in this plan or with another idea about how to find the discrepancies. Thank you. Flanzy

[aaa]

You must create relation between each two files by inventory number. Then one field which=-1 if Isempty(Relation::Inventory). Sort by this field and you see discrepancies. If you want attach me any two files with inventory# i try to do it.

[Steve T.]

Howdy, Flanzy! aaa's idea is probably smarter and best, but before reading it, I would have combined the inventory numbers into 1 temporary database and then used FM's plain old FIND to

FIND > OMIT > (symbol ! duplicates) in the inventory # field

Normally, you would expect to find each inventory number twice, so I think searching for duplicates and omitting them will leave you with numbers that only appear once. I suppose you can include a reference field to identify which database the number is from if you suspect there's a lot of them.

--ST

[Flanzy]

Steve, I'll take your suggestion as a back-up but will see if I can make aaa's idea work. Thank you both.