Show Parent once and all Children on form in Text boxes

Originally Posted by Fifer

I have a table with 2 fields "system" and "subsystem" I would like to show the recordsets in a form with the system field showing only one time but all of the related subsystem fields shown on the form, perhaps in Text boxes not using Combo boxes...see below..

Table
system---------subsystem
1--------------------1-100
1--------------------1-200
1--------------------1-300
1--------------------1-400
2--------------------2-100
2--------------------2-200
2--------------------2-300

Form
system--------subsystem
1-------------------1-100
---------------------1-200
---------------------1-300
---------------------1-400
2-------------------2-100
---------------------2-200
---------------------2-300

As above the system field would only show one time...

I'm just stuck with this...

B

Originally Posted by Fifer

Subform is a great idea, I have tried it and it works for me!, any idea how to show the dataset but without the rows and grid? I just want it all grey as if it was a form...switching to single form or continuous forms is not what I need, I've tried that..

Fifer