Look up field in a table

[Guest]

With table (1) I want to use a look up field to choose multiple columns of
data from table (2).

Table 2 has 4 columns I would like to bring over by choosing the data, the
problem is I have one field to choose. with out creating a look up in each
column, this can mean choosing the wrong data.

I can however create a query to see the data.

Is there a way I can create this at the table without making a query?

Thanks

 

[John Vinson]

With table (1) I want to use a look up field to choose multiple columns of
data from table (2).

Table 2 has 4 columns I would like to bring over by choosing the data, the
problem is I have one field to choose. with out creating a look up in each
column, this can mean choosing the wrong data.

I can however create a query to see the data.

Is there a way I can create this at the table without making a query?

Thanks

Queries are the BACKBONE of any Access application.

Tables are for data storage, not for data presentation or editing -
use Forms based on queries for that purpose.

Most of the experts here dislike the Lookup Fields and Subdatasheets
features, and recommend that they not be used at all.


John W. Vinson[MVP]

 

[Larry Linson]

"John Vinson" wrote

Most of the experts here dislike the Lookup Fields
and Subdatasheets features, and recommend that
they not be used at all.

Considering that these "features" violate Relational Database design
principles, a recommendation not to use them at all seems perfectly
justified.

Larry Linson
Microsoft Access MVP

 

[John Vinson]

"John Vinson" wrote


Considering that these "features" violate Relational Database design
principles, a recommendation not to use them at all seems perfectly
justified.

Which makes their decided expansion and emphasis in Access2007
particularly frustrating!!!

John W. Vinson[MVP]

 

[Larry Linson]

"John Vinson" wrote

Which makes their decided expansion and emphasis
in Access2007 particularly frustrating!!!

Ack! Don't get me started on "complex data" and linking to SharePoint lists!
"Frustrating" is putting it mildly.

Larry