Multiple rows within multiple rows

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
 
G

Guest

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
 
A

Albert D.Kallal

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......
 

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