Opening Lookup Table

J

JamesJ

Access 2007 sp2
When I open a lookup table directly form my backend db the records have the "+"
allowing me to expand and show the records associated with that particular lookup record. (Movie genre in this case)
But, when I open the linked table in my front end db the "+" signs aren't there.
Is there a way have the same thing occur (see records associated with the particular movie genre) from my
from end db???

Thanks,
James
 
J

John W. Vinson

Is there a way have the same thing occur (see records associated with the particular movie genre) from my
from end db???

By using a Form, with a Subform, rather than the very inefficient and limited
subdatasheet view.

Tables are not designed for data interaction, other than "quick and dirty"
looks. For productive interaction with your data, Forms are essential.
 
J

JamesJ

And the Subform based on the Lookup table will satify my need here?

James
Is there a way have the same thing occur (see records associated with the particular movie genre) from my
from end db???

By using a Form, with a Subform, rather than the very inefficient and limited
subdatasheet view.

Tables are not designed for data interaction, other than "quick and dirty"
looks. For productive interaction with your data, Forms are essential.
 
J

John W. Vinson

Certainly should. You'ld use the linking field between the two tables as the
Master/Child Link Field.
 
B

Bilky_White

Certainly should. You'ld use the linking field between the two tables as the
Master/Child Link Field.

And not only that, you should turn off the sub-datasheet view as it can
affect performance.
 
J

JamesJ

Ok

Thanks,
James
Certainly should. You'ld use the linking field between the two tables as the
Master/Child Link Field.

And not only that, you should turn off the sub-datasheet view as it can
affect performance.
 
J

JamesJ

Ok. I'll give it a shot.

Thanks,
James
Certainly should. You'ld use the linking field between the two tables as the
Master/Child Link Field.
 

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