How to setup multiple map table relationships in one view [solved]

I'm writing a module to handle migration of user_realationships from another module (in my case buddylist)

The buddylist table has the all the basic info, but i needed to map both the uid and bid to the user_map table I used when i imported my users. I added the buddylist table and setup the relationships with tw, but when i tried to setup the field in the view, I could only get the first mapping field to show up.

The answer was to add the same field twice, then edit the second field and change the relationship to the one you re looking for manually. The relationships appear as the table name, which is exactly the same so you have to guess, but they are in the same order as the views relationships. I would also set a label here to avoid confusion about what new id is what.

This drove me nuts trying to figure out, so I hope it helps someone else. Putting the map tables to dual use will come up any time you want to add a table that references two different ids of the same mapping type (privatemsg, buddylist, friendlist, nodereference?, user_relationships, etc).

If someone what to flesh this out, we can add it to the documentation