Opening Lookup Table

[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

 

[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.

 

[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.

 

[John W. Vinson]

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

 

[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.

 

[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.