Newbie could use a push in the right direction

[aherrera]

Just started tinkering with FM7 yesterday. I've gotten a pretty good start for not really knowing what I'm doing! But now I'm stumped on something specific, so if anyone could point me to a good tutorial or a thread that I've missed in my search, that'd be great. Here's my problem:

I'm trying to create a project management database. I've got most of it going good. In the main screen (project), I want to add at least one task, but have the ability to add more. Also, it isn't just a list of tasks - in addition to the task name, it also needs to display cost, hours, rate and notes.

Any ideas?

Thanks!!!

[jhomer]

i dont have any tutorial links to send you but heres an idea:

create a table called TASKS or somthing to that effect. populate this table with fields specific to each task (your cost, hours, rate, etc.) and also include a unique identifier for each task (TASKID)

place another field in your project management table also called TASKID and then relate these two tables based on TASKID=TASKID. This can be done by going to the define datebase menu then selecting the relationship tab. make sure you see both table occurences on the relationship graph and then click and drag on the field name taksid and connect it to the other task id.

that last part may sound a little confusing but its actually very easy once you get there.

you can add new records to your task table as needed and they will be available throughout your file

[sbg2]

There can be 0 to many tasks for each project, not many projects for each task. You want to base the relationship on ID_Project for both tables not ID_Task.

example attached

Project.zip

[jhomer]

thanks for the correction