johndoomed
VBA idiot
- Local time
- Today, 08:22
- Joined
- Nov 4, 2004
- Messages
- 174
Hello!
I've made a "match making"-database for an B2B-event. In short: About 65 companies is getting 10 meetings each. I've made tbl_meeting with 3 columns:
meetID
Company1
Company2
The question is: How to I search for duplicate combinations? Look at the attached image for example - meetID 2 and 5 is a duplicate combo.
I just can't get my head around how to identify the duplicate combinations - so any help would really be appreciated!
I've made a "match making"-database for an B2B-event. In short: About 65 companies is getting 10 meetings each. I've made tbl_meeting with 3 columns:
meetID
Company1
Company2
The question is: How to I search for duplicate combinations? Look at the attached image for example - meetID 2 and 5 is a duplicate combo.
I just can't get my head around how to identify the duplicate combinations - so any help would really be appreciated!