Opening Lookup Table

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

On Tue, 12 Jan 2010 11:09:39 -0500, "JamesJ"
wrote:

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 [MVP]

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

James
"John W. Vinson" wrote in message ...
On Tue, 12 Jan 2010 11:09:39 -0500, "JamesJ"
wrote:

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 [MVP]

On Tue, 12 Jan 2010 12:23:39 -0500, "JamesJ"
wrote:

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

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

James
"John W. Vinson" wrote in message ...
On Tue, 12 Jan 2010 11:09:39 -0500, "JamesJ"
wrote:

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 [MVP]
--

John W. Vinson [MVP]

On 12/01/2010 18:59, John W. Vinson wrote:
On Tue, 12 Jan 2010 12:23:39 -0500,
wrote:

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.

Ok

Thanks,
James
"Bilky_White" wrote in message ...
On 12/01/2010 18:59, John W. Vinson wrote:
On Tue, 12 Jan 2010 12:23:39 -0500,
wrote:

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.

Ok. I'll give it a shot.

Thanks,
James
"John W. Vinson" wrote in message ...
On Tue, 12 Jan 2010 12:23:39 -0500, "JamesJ"
wrote:

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

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

James
"John W. Vinson" wrote in message ...
On Tue, 12 Jan 2010 11:09:39 -0500, "JamesJ"
wrote:

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 [MVP]
--

John W. Vinson [MVP]