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
charosAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

dqmqCommented:
The simple way is use a subform control and set the default view of the form it contains to a datasheet.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
charosAuthor Commented:
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.
0
Jeffrey CoachmanMIS LiasonCommented:
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
0
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

charosAuthor Commented:
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
0
Jeffrey CoachmanMIS LiasonCommented:
There is no control that I know of that will display related data in this fashion.

In response to DQMs suggestion:
  <use a subform control and set the default view of the form it contains to a datasheet.>
You stated:
<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.>
Then don't use a button, use a checknbox?
A check box could be made to do the exact same thing. "Hence" a datasheet suform would work quite nicely.
;-)

JeffCoachman
0
charosAuthor Commented:
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
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.