Accidentally removed subdatasheet

[mcjanes]

I have a table related to two other tables in a one-to-many
relationship. Access gave me the option of choosing between two
subdatasheets. I chose one, but later on decided to change it to the
other. Somehow I deleted the subdatasheet, but now I can't get it
back! How can "re-attach" one of the subdatasheets to this table? The
"Subdatasheet" option under the Format menu is greyed out. Is there
any way other than re-doing the table from scratch?

 

[mcjanes]

Nevermind...I figured it out.

 

[John Vinson]

I have a table related to two other tables in a one-to-many
relationship. Access gave me the option of choosing between two
subdatasheets. I chose one, but later on decided to change it to the
other. Somehow I deleted the subdatasheet, but now I can't get it
back! How can "re-attach" one of the subdatasheets to this table? The
"Subdatasheet" option under the Format menu is greyed out. Is there
any way other than re-doing the table from scratch?

Don't bother. Subdatasheets only help if you view or edit data in
table datasheet view - and you should only do so for very rough
quick&dirty hacking. Any productive use of Access will benefit from
setting all Subdatasheets to None, and using Forms with Subforms in
order to interact with your data.

John W. Vinson[MVP]

 

[mcjanes]

Thanks for the tip.

I realize this, but I was in the very early stages of creating my
database, i.e. setting up the tables and relationships. Subdatasheets
come in handy at this stage, because I wanted to add a record or two
for "testing" purposes, in case I goofed somewhere along the way...