Parent child form

[Guest]

I want to design a form accessing two different tables.

I should be able to add/delete/modify records in both these tables together.
How can I do it?

Here is how it should look like ...

----------------Data Entry for Projects-------------------
Product
Name
etc.

-------------
Location at : <name of the person say xxx>
From Date: could be 1/1/05
To Date: 3/31/05
------------
Location at : < name of the person say yyy>
From Date: 4/1/05
To Date: <blank as its still here>
------------
--------------------- end of Line ----------------------

Can somone point me on how to proceed?

Thank you,
-Me

 

[Steve Schapel]

Me,

The basic concept here will depend on whether you will want to record a
particular person as part of more than one Project. If not, you will
simply need a field in the Persons table to identify the ProjectID of
the Project they are located at. Otherwise, you will need a Locations
table to record the locating of which Persons to which Project - in
which case, this article may be of assistance:
http://accesstips.datamanagementsolutions.biz/many.htm

Either way, you will have a form based on the Projects table, and
another form in Continuous View, based on the other table(s), and this
second form is placed on the first form as a subform.

 

[Guest]

Hi Steve,

I was looking for something like this - thanks.
How do I link the form with subform?

I created main form and added the subform to it, I would like to connect
portion of key from main form to the subform. In my case it would be the
product.

Thank you,
-Me

 

[Steve Schapel]

Me,

This is controlled by the Link MasterFields and Link Child Fields
properties of the subfrorm, i.e. look at the design view of the main
form, select the subform control, and look at tis properties. Enter the
name of the field that is the basis of the relationship between the main
form and the subform.