Opening Lookup Table

  • Thread starter Thread starter JamesJ
  • Start date Start date
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
 
Is there a way have the same thing occur (see records associated with the particular movie genre) from my
from end db???
Click to expand...

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.
 
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???
Click to expand...

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.
 
Certainly should. You'ld use the linking field between the two tables as the
Master/Child Link Field.
 
Ok

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

And not only that, you should turn off the sub-datasheet view as it can
affect performance.
 
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.
 
Back
Top