Accidentally removed subdatasheet

  • Thread starter Thread starter mcjanes
  • Start date Start date
M

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?
 
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?
Click to expand...

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]
 
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...
 
Back
Top