form / subform linking

A

AntonioRio

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 use the subform 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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top