Can I have siblings in a banded data access page?

[Mark Hinnebusch]

I am trying to build a data access page that has a top level section with data from one table and multiple banded sections, each of which is subordinate to the top level. What seems to be easy to do within the Access Pages GUI is to create a report that has a parent-child-grandchild-greatgrandchild... structure, but what I can't figure out how to create is a parent-child1,child2,... structure.

I think this restriction exists in Access reports and the VB report objects as well, but I don't have much memory of a work-around, if there even is one.

I'd like to avoid script if at all possible and just use the drag-and-drop features of the Pages GUI.

Any help is gratefully appreciated!

thanks,
mark hinnebusch

 

[Mark Hinnebusch]

Joseph,

Thanks for your quick reply. My problem is being able to have two children of a parent on the same form. You can have multiple subforms in Access forms, but in Access Data pages, it seems to use the report model that only allows one child per parent. (But I am hoping that I am wrong about this, hence my question.)

thanks,
mark

 

[Mark Hinnebusch]

Joseph,

Here is my situation. I have a table of test cases.
Associated with each test case is a set of files. Also
associated with each test case is a set of prerequisites.
There is no relationship between the files and the
prerequisites, so they share no common key. However,
they both relate to the test case record and each tables
prime key is a foreign key in the test case record.

The parent record in the web form is to be the test case
record. I want two banded sections, one for the files and
one for the prerequisites. The GUI lets me create a
banded section for the files, under the test case record,
but will only let me create the prerequisite section as a
child of the files section, not the test case section,
which is what I need and which properly reflects the
structure of the database. Alternately, I can create a
banded section for the prerequisites under the test case
section, but then the files section insists on being
subordinate to the prerequisites section, again, not what
is needed.

I didn't understand your suggestion. If my explanation
above matches what you understand of my problem, then can
you elaborate a bit on your suggestion?

thanks!
mark

 

[mark hinnebusch]

You are reading it right and those relationships do
exist. With access forms, I can have multiple child forms
and can easily do what I need. With data access pages,
however, I can't figure out how to have two child forms.
That is the crux of my problem.

thanks,
mark

 

[mark hinnebusch]

Thanks for trying. There aren't many people who take the
time to respond on these lists and I appreciate your
efforts.

I guess I will have to do it in VB instead of using data
access pages. It looked like an easy way to go.

thanks, again,
mark