form / subform linking

[Guest]

I have a table containing projects and related data (tblProject)

I want to build a form where the user can choose a project from a combobox
and have a subform appear. This subform should contain 2 columns (“Project
Activity†and “Project Activity Descriptionâ€).

I want the user to be able to type the activities and their descriptions for
the selected project, and I want this data to be stored in a table. So the
next time user opens the form, he can select a project from the combobox and
see or change its activities and descriptions.

I don't know how to build the form, the subform, how to link them, if
projects activities should be in another table (different from tblProjects,
since it's a one to many relationship). I'm lost!
I’m new to Access and don’t know much about forms, queries, table
relationships… Help!!

I have several doubts… Need serious help since I’ve tried “everything†and
nothing seems to work.

Thanks
Antônio Machado

 

[Steve]

Your tables need to be:
TblProject
ProjectID
ProjectName
etc

TblProjectActivity
ProjectActivityID
ProjectID
ProjectActivity
ProjectActivityDescription

After creating the tables, you need to establish a relationship by joining
ProjectID in both tables.

To create the form/subform, you can use the form wizard. First create the
form based on TblProject and then tell the wizrd you also want to include
TblProjectActivity. You then just need to follow the directions from there.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

 

[Guest]

ok. I already have a table with all the 80 projects and I’ve created the
TblProjectActivity.

1) How do I set the projectID field on this table? I copy the column
ProjectID from the TblProject?

I also created the form the way you told, but now I have new problems:

Thewith ProjectID and ProjectName from TblProjects, and ProjectID,
ProjectActivity and ProjectActivityDescription in the subform.

But all the fields are text boxes.

2) I changed the textbox to combobox and now when I click on the arrow in
the combobox, the list is empty. What do I have to do to populate it with the
projects and be able to pick a project form the list so it automatically
returns its activities?

3) I want the user to choose the project by its name (ProjectName) not its
number (ProjectID).

Thank you again.
Antonio Machado.