PLEASE forgive my knowledge lapse, I've not used Access in a long time and I'm wanting to put together a seemingly simple db and just can't think of the best way to do it. Could someone start me on the right path?
There is a fraudulant auction user that a group of us are trying to track down all of her different user IDs. She uses her different IDs to buy from herself so she looks credible. I'm trying to put together a db showing what commons IDs are used -- there are hundreds. (Does this make sense?)
For example:
Seller:
UserBOB
Buyers:
BuyerANN
BuyerKIM
BuyerLOU
Seller:
SellerJIM
Buyers:
BuyerSARAH
BuyerKIM
BuyerBOB
So the two sellers have common buyers (including each other). I want to be able to pull a report linking seller to seller by their common buyers (including the sellers in the buyer list). This will help me track down all of the fraudulant user IDs.
Thanks to anyone who understands this and might be able to help me.