Importing old flat file into a new relational database.
Our old database had one file for all our products. Our new database is going to use a relational database but I am having trouble figuring out how to bring in the data.
For example the new database will have products and desingers in two tables, the problems is that there is going to be a join table called assignments (since one product can have multiple designers and one designer can work on multiple products).
I think I can fiugre it out if it were a direct relationship but the join table is throwing me, any help would be appreciated.