Show/Hide expand indicator
in [General]
|
From: pinewild on 7 Jul 2008 12:03 I'm used to seeing the expand indicator (+) for tables which have a one to many relationship. One of my tables does not show this indicator in the datasheet view and I can't find how to turn it back on.
From: Wayne-I-M on 7 Jul 2008 12:17 Open the table Select View Select Subdatasheet Select the table you wish to act as the sub data sheet -- Wayne Manchester, England. "pinewild" wrote: > I'm used to seeing the expand indicator (+) for tables which have a one to > many relationship. One of my tables does not show this indicator in the > datasheet view and I can't find how to turn it back on.
From: pinewild on 7 Jul 2008 12:52 Wayne, Subdatasheet is not available for this table. It is also not available when I choose Datasheet / Records / More. The word datasheet is dim. Mary "Wayne-I-M" wrote: > Open the table > Select View > Select Subdatasheet > Select the table you wish to act as the sub data sheet > > > -- > Wayne > Manchester, England. > > > > "pinewild" wrote: > > > I'm used to seeing the expand indicator (+) for tables which have a one to > > many relationship. One of my tables does not show this indicator in the > > datasheet view and I can't find how to turn it back on.
From: pinewild on 7 Jul 2008 13:00 I meant to say the word subdatasheet is dim. "pinewild" wrote: > Wayne, > Subdatasheet is not available for this table. It is also not available when > I choose Datasheet / Records / More. The word datasheet is dim. > Mary > > "Wayne-I-M" wrote: > > > Open the table > > Select View > > Select Subdatasheet > > Select the table you wish to act as the sub data sheet > > > > > > -- > > Wayne > > Manchester, England. > > > > > > > > "pinewild" wrote: > > > > > I'm used to seeing the expand indicator (+) for tables which have a one to > > > many relationship. One of my tables does not show this indicator in the > > > datasheet view and I can't find how to turn it back on.
From: JulieS on 7 Jul 2008 13:22
Is the table linked from another database? You cannot insert a subdatasheet on a linked table. I hope this helps. Julie "pinewild" wrote in message news:1A88622C-D5DA-4E78-8B32-C19CF20D19C4(a)microsoft.com... >I meant to say the word subdatasheet is dim. > > "pinewild" wrote: > >> Wayne, >> Subdatasheet is not available for this table. It is also not >> available when >> I choose Datasheet / Records / More. The word datasheet is dim. >> Mary >> >> "Wayne-I-M" wrote: >> >> > Open the table >> > Select View >> > Select Subdatasheet >> > Select the table you wish to act as the sub data sheet >> > >> > >> > -- >> > Wayne >> > Manchester, England. >> > >> > >> > >> > "pinewild" wrote: >> > >> > > I'm used to seeing the expand indicator (+) for tables which >> > > have a one to >> > > many relationship. One of my tables does not show this >> > > indicator in the >> > > datasheet view and I can't find how to turn it back on. |