I'm trying to normalize a very simple dataset:
user_id | role_id
I have a table with 60,000 records, and all I need to do is turn this into a join, so one table contains users, and another table contains roles, with this table becoming a simple join.
The Table Analyzer Wizard should handle this perfectly, but when I come to the step of clicking Finish, I get the error 'Cannot define field more than once', and it fails. Any suggestions on how to either get the wizard to work properly, or a different way to get this table normalized?