Forms/Subforms

[Steven W]

I wish to link updateable information on two forms. On
the 'master form' I add a new record (ie. go to last field
which is blank), which describes basic information about
projects. I'd like to be able to add further information
regarding Subcontractors which is linked to the new
record, but display this on a separate page? form?. Is the
answer a subform? and are these able to be displayed as a
separate page to the Master? I'd like to be able to
display the subcontractor information as supposedly
separate info to the main information.
many thanks.

 

[John Vinson]

I'd like to be able to add further information
regarding Subcontractors which is linked to the new
record, but display this on a separate page? form?. Is the
answer a subform? and are these able to be displayed as a
separate page to the Master?

A Subform based on the "many" side table is indeed the best solution.
If you want to see the information separately, one useful technique is
to use a Tab Control on the form; put the Contract information on page
1 of the tab control, and the Subform on page 2.

 

[Ken Snell]

From what I am understanding of your description, yes, a subform would be
the way to do this. You can link the subform records to the main form
records via the "Link Child Fields" and "Link Master Fields" properties of
the subform control (the control that holds the subform). There is info in
the Help file about doing this. Post back if you have specific questions.