Look up field in a table

  • Thread starter Thread starter Guest
  • Start date Start date
G

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

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]
 
"John Vinson" wrote
Most of the experts here dislike the Lookup Fields
and Subdatasheets features, and recommend that
they not be used at all.
Click to expand...

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" wrote


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

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

John W. Vinson[MVP]
 
"John Vinson" wrote
Which makes their decided expansion and emphasis
in Access2007 particularly frustrating!!!
Click to expand...

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

Larry
 
Back
Top