Very Computer

by **Rob** » Fri, 05 Jul 2002 06:19:41

I don't know if this can be done but if someone could point me in the right
direction it would be appreciated:

I have several tables that track history information and are all linked to a
single record in a master table.

Using ADO can I link several datagrids to a single record in a recordset and
then scroll through those records and the datagrids update accordingly?
(Similar to a Master\Detail Form but with multiple details)

by **Douglas Laudenschlager [M** » Fri, 05 Jul 2002 07:44:38

For a quick start, I'd probably let the VB6 Data Form Wizard (assuming
you're talking VB) create a master/detail form for me, then simply copy and
adapt the "detail" pieces as necessary for multiple detail recordsets and
datagrids.

-Doug

This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure? For information about the Microsoft Strategic Technology
Protection Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.

by **Nelson Le** » Sat, 06 Jul 2002 02:15:07

Yes, it can be done. Use the ADO Shape command to create your hierarchy
(extend the Shape syntax in the master\detail form to tie the single Master
to multiple details)

HTH

Nelson

Quote:> I don't know if this can be done but if someone could point me in the
right
> direction it would be appreciated:

> I have several tables that track history information and are all linked to
a
> single record in a master table.

> Using ADO can I link several datagrids to a single record in a recordset
and
> then scroll through those records and the datagrids update accordingly?
> (Similar to a Master\Detail Form but with multiple details)

by **Nelson Le** » Sat, 06 Jul 2002 02:18:25

If you need help with the ADO Shape syntax try this link

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q189657

It provides some examples to help you get started.

Nelson

> Yes, it can be done. Use the ADO Shape command to create your hierarchy
> (extend the Shape syntax in the master\detail form to tie the single
Master
> to multiple details)

> HTH

> Nelson

> > I don't know if this can be done but if someone could point me in the
> right
> > direction it would be appreciated:

> > I have several tables that track history information and are all linked
to
> a
> > single record in a master table.

> > Using ADO can I link several datagrids to a single record in a recordset
> and
> > then scroll through those records and the datagrids update accordingly?
> > (Similar to a Master\Detail Form but with multiple details)

Very Computer

Link multiple datagrids to a single record (Master\Detail Form with multiple details)

Link multiple datagrids to a single record (Master\Detail Form with multiple details)

Link multiple datagrids to a single record (Master\Detail Form with multiple details)

Link multiple datagrids to a single record (Master\Detail Form with multiple details)

Link multiple datagrids to a single record (Master\Detail Form with multiple details)