Subdatasheet

[Guest]

I've defined my relationships between the tables but when I go to table view
I don't see any '+' to expand the subdatasheet.

Do I need to add the subdatasheet? I thought it was automatic when I define
the one to many relationship....


Christian

 

[Steve Schapel]

Christian,

If you go to the design view of the table, and look at the table
Properties, check the Subdatasheet Name property. The recommended
setting is '[None]' but this will not give you the kind of functionality
you are asking for. Set it to '[Auto]' or to the name of the "many" side
table, to allow you to look at the subdatasheet during your development
and testing phases, then set it back to '[None]' when the database is
ready for usage via forms.

 

[John Vinson]

I've defined my relationships between the tables but when I go to table view
I don't see any '+' to expand the subdatasheet.

Do I need to add the subdatasheet? I thought it was automatic when I define
the one to many relationship....

I'd recommend not using datasheets (or subdatasheets) at all, except
for debugging.

Use a Form based on your "one" side table with a Subform based on the
many side (or, if you have more than one related table, use more than
one subform - something that you CANNOT do with subdatasheets).

John W. Vinson[MVP]