One-to-many using subform - can it be dynamic?

[asp3232]

Hi,

I've got a DB set up which tracks issues, causes, etc. for projects. My primary table has an ID field (primary key) and I've got a table tracking the issues, causes, and some other info.

Each project can have multiple issues and causes (but may not have any). What I'd like to do is have a subform that allows me to see any and all issues and associated info for the project in question.

I've currently got a subform that shows one issue/etc at a time with an additional navigation control for the subform, which works just fine (showing only the issues & causes associated with the project in question), but I'd like to have all issues, etc be visible at once (and have a blank set of fields available for input below the existing issue information).

Is there a way to do this, or am I just out of luck?

thanks!

asp

 

[LittleSmudge]

NO PROBLEM

Just make the design of your subForm into "CONTINUOUS" instead of "Single View" as it is at the moment

( Change the value in the "DefaultView" parameter of the form design )

You will need to do a lot of changes to the layout of the controls and their labels of course.



QED?

G LS

 

[asp3232]

That looks like it'll do it! Thanks a bunch!

asp