Multiple rows within multiple rows

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

Guest

I am trying to build a form using 2 tables in a 1 to many relationship as
follows :-

table 1 - code and name
table 2 - id, code(PK), start and end date

In most cases only 1 entry will exist for table 2, but someone may leave and
return multiple times.

On screen I would like to see

code name
code name
code name
code name
code name
code name
code name

then for each highlighted record only one or more lines showing
corresponding date info :-

start date end date
start date end date
start date end date

This is soemwhat the reverse of the norm of single line - multiple lines used.
Can this be done using Wizards or do I need to emply the old elbow grease
and do it all manually? and if so any tips.

Cheers,
Steve
 
Hi, Ace.

You can't build such a form because Access does not permit a subform on a
continuous form. You could, however, place a command button on a continuous
form to open another form which displays the detail. You can create both
forms using the wizard, and use the command button wizard to add the button
in form design view, selecting Form Operations, Open Form, and choosing the
option to open it with specific data to display, matching the code number.

Sprinks
 
Well, you can't have a continues continues sub form in a form, but you
certainly can place two sub forms on ANOTHER form, and get the same results.

Take a look at the following screen shots to see what I mean....

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

The above screen shots shows how easy it is to display two sets of data, and
both are continues forms, and on the same screen......
 
Back
Top