Advantages of Subdatasheets

  • Thread starter Thread starter Charles D Clayton Jr
  • Start date 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
 
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?
 
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?
 
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.
 
Back
Top