Advantages of Subdatasheets

  • Thread starter Charles D Clayton Jr
  • Start date
C

Charles D Clayton Jr

Does anybody know of any advantages to using subdatasheets? Is there
a particular situation where you would want to nest your tables this
way?

Thanks,

Charles D Clayton Jr
 
M

Mike Matheny

I am creating a database for my IT company that has client info in it - I
have a preventative maintenance table, that is a subdatasheet of the
customer equipment table, and that is a subdatasheet of the customer master.
I can open a customer, click the + and open the subdatasheet for equipment,
and then click the + and open the PM tasks for that piece of equipment.
Problem is, I can't find any way to bring this similar info into a form, and
I can't code events into a table! Anyone have any help on this?
 
M

Mike Matheny

I've already got that - the main form selects the customer, then I have
several subforms that have user info, software info, equipment info, notes,
work done, etc. tied to the main form. I cannot add a subform to the
equipment subform to get the data I want. Any other way?
 
K

Ken Snell

I am assuming that your statement regarding you cannot add a subform to
another subform is because the subform is a continuous forms view? If so,
try putting the subsubform in the subform's FormFooter section and then link
it to the subform.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top