subdatasheet

J

Jamie

How do I creat a subdatasheet? I have one table with
building names and numbers and managers etc... I want to
be able to view the contact information for each manager
in a dropdown format. I know it's possible, I just don't
know how to do it.

-Jamie
 
J

John Vinson

How do I creat a subdatasheet? I have one table with
building names and numbers and managers etc... I want to
be able to view the contact information for each manager
in a dropdown format. I know it's possible, I just don't
know how to do it.

-Jamie

Well...

DON'T.

Table datasheets are of VERY limited capability and should not be used
routinely, only for debugging.

Create a Form based on your Building table, with a Subform based on
the Contact table. Access provides Forms for this very purpose. You'll
find them much easier to use than table datasheets, once you invest a
modest amount of time building one.
 

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