Relationships of two tables

[swpowe]

I'm trying to work of the "tasks" template to create a database that will allow me to have multiple projects and each project having it's own multiple tasks. The problem I run into is importing my tasks from an excel spreadsheet. I need to be able to either create a project or assign tasks two a project while importing from my spreaadsheet. I've got spreadsheets that have many lines of "tasks" and then infor for each task and I need to be able to put those tasks under a project. I can't seem to figure it out. If I import them to the "tasks" table in the template it doesn't create a project and I can't figure out a way to import while i'm looking at the "project" page. As I'm sure you can tell I'm kind of a newbie at this. thanks for any and all help on this.

[Fitch]

I don't have the tasks file, but I assume that you have a projects table and a tasks table related by project id. So, create a new project and note the id. Then import your tasks into the tasks table. When your import is complete your found set should consist of only the imported records. Last step is use the Replace command to change the project id of the tasks to the id of the "parent" project record you just created.