data manager will create scripts automatically for you in data load editor. Data Load editor is just more powerful but also involves a bit a of learning curve.
Associations between tables are automatically formed using common column names. e.g. if table Order contains columns OrderID, CustomerID,.. etc. and Customer table contains CustomerID , CustomerName etc. both tables will automatically associated with each other using column CustomerID.