Form/Subforms

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a database with these relationships:
one name to many jobs
one job to many dwgs
one job to many docs

I can build a form that contains subforms (example)
name then showing jobs
jobs showing dwgs

I cannot build a form that contains:
name then jobs
click on jobs to show dwgs in one subform and to show docs in another subform

Is this possible? Not using any code here, just simple wizzards.
 
You can do as you ask.

The simplest thing would be to create a main form bound to the Jobs table,
with a combo box where you choose the name for the job when creating a new
entry. Then add two subforms - one bound to the dwgs table, and the other to
the docs table. If you are short of space, you could put them in 2 pages of
a tab control.
 
I actually have the main form bound to the names table. When i choose a
name, the jobs subforms show associated jobs. When I choose a job, a subform
below that shows associated dwgs. I'm trying to get it to show dwgs in one
subform and docs in another below it, based on the job, based on the name.
The wizard seems to work with associated dwgs or associated docs but cannot
show both.

is it possible to email this to you to review?
 
You can use a main form, and use two sub-form

(so, don't put a sub-form withing a sub-form...but side by side).

I got some screen shots here of that idea:

http://www.members.shaw.ca/AlbertKallal/Articles/Grid.htm

So, you can even build 3 grids using continues forms, or 3 forms in data
sheet view.

You then create a 4 form, and drop in the above 3 forms.

In the master form (which is now a subform), in the on current event, you
place the following command to make the child forms follow this form.

me.Parent.Child1.Requery
me.Parent.Child2.Requery.


In the link child/master settings for child 1, you place:

linkChildFields main_id (whatever is the name of the field in
this sub-form that is used to relate back to the parent table)
LinkMasterFields [MasterForm].[form].[ID]

In the link child/master settings for child 2 form you place

linkChildFields main_id (whatever is the name of the field in
this sub-form that is used to relate back to the parent table)
LinkMasterFields [MasterForm].[form].[ID] ("masterForm" is the name of
the contorl you used to hold the master form).
 
Is there a way to access your screen shots other than by the link below. I
work for the Air Force and our computer firewalls (i guess) won't allow me to
access the link you have for your screen shots.
 
Back
Top