asked on

Parent/Child data control for MS Access

I need to have a control that will allow the parent records to be listed, with a plus sign (+) to the left of the control. When clicked, the child records will be displayed under the parent record

i.e.
Heading1 Heading2 Heading3 Heading4 Heading5 ...
---------------------------------------------------------------------------------
(+) Parent1 SomeData MoreData MaybeAdate MoreData Etc
(+) Parent2 SomeData MoreData MaybeAdate MoreData Etc
(+) Parent3 SomeData MoreData MaybeAdate MoreData Etc
(+) Parent4 SomeData MoreData MaybeAdate MoreData Etc

Note: I need individual editable fields, not a string of characters as in the Tree control

When I click on the '+' next the Parent3, the following is displayed:

(+) Parent1 SomeData MoreData MaybeAdate MoreData Etc
(-) Parent2 SomeData MoreData MaybeAdate MoreData Etc
SubHead1 SubHead2 SubHead3 SubHead4 ...
-------------------------------------------------------------
ChildDta1 MoreData MoreData MorData
ChildDta2 MoreData MoreData MorData
ChildDta3 MoreData MoreData MorData
ChildDta4 MoreData MoreData MorData
(+) Parent3 SomeData MoreData MaybeAdate MoreData Etc
(+) Parent4 SomeData MoreData MaybeAdate MoreData Etc

I don't care about the layout, but these fields need to be discrete and editable.

When a table is in datasheet mode, it acts this way. How can I do this in a form?

This is a commercial project, so if I need to purchase a control, that's OK.

Thanks!
Data-Grid-Example.gif

ASKER CERTIFIED SOLUTION

dqmq

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

charos

ASKER

There is a Boolean field on in the record set that I need to front-end with a push button. As such, the datasheet is a sub-optimal solution.

Jeffrey Coachman

Your reply to dqmq is difficult to understand.

<There is a Boolean field on in the record set >
1. You made no mention of any "Boolean" field in your original question.

2. <that I need to front-end with a push button. >
I have no idea what this means.

3. <As such, the datasheet is a sub-optimal solution.>
Then can you please post a graphical example of *exactly* what you need?

My guess is that you need a "List View" or "Tree View" control.

JeffCoachman

charos

ASKER

Thanks for the follow up questions. Attached please find a mock up of the form I would like to create.

The 'push-button' is associated with a Yes/No type field (i.e. Boolean).

<<
My guess is that you need a "List View" or "Tree View" control.
>>
It would be great if there was a pre-existing control for this!

Thanks!

- BIll
Control-Mockup.gif

SOLUTION

Jeffrey Coachman

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

charos

ASKER

Thank you for the information. The information about the form control not being available was almost as important as the final answer, which was answered immediately and correctly. Thanks for your expertise.

- Bill Carpenter