AnsweredAssumed Answered

Importing old flat file into a new relational database.

Question asked by silba2021 on Nov 20, 2011
Latest reply on Nov 22, 2011 by philmodjunk

Title

Importing old flat file into a new relational database.

Post

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.

Outcomes