auto lookup

[Steve Byrd]

I am a web deisgner using an access database to present data on a web page. I
have created two tables, each with three columns. Table one, which is
complete with all the relevant data, has "event number, event description,
and "start time".

Table two, which is the new table, has event number, description, and
results. What I would like to is populate the "description" column based on
the entry of the event number in the "event number" column. Like a vlookup in
excell.

I used the lookup wizard and created a drop down box in the "description"
column but I just want the cooresponding description from table one, not a
choice of all the descriptions in table one. Both tables have primary keys.


I found some answers here in the forum but I don't have the vocabulary for
to understand the answers. Combo box and querry string are foriegn terms to
me, at least in the world of access.

I'd appreciate a third grade level source for the answer to this problem.
Thanks very much.

 

[Duane Hookom]

If I understand correctly, you want to update table two with the description
from table one. This would be poor practice. You can create a query with
both tables that joins on the Event Number fields and include any desired
fields from both tables.

Duane Hookom
MS Access MVP

 

[Steve Byrd]

Great, suburb...

Now again at the third grade level, how do I do that? I don't understand
querry and join. The how is not as important as the result, meaning I'd
like to do it right.

On table number two, if enter "1" in the event number how do I populate
"road course" in the description column of table number two. road course is
defined as event number 1 in talbe number one.

 

[John Spencer]

Open a new query
== Select both tables
== Drag from Event Number to Event Number to create the join
== Add the fields you want to see to the fields column

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

 

[John W. Vinson]

Now again at the third grade level, how do I do that? I don't understand
querry and join. The how is not as important as the result, meaning I'd
like to do it right.

On table number two, if enter "1" in the event number how do I populate
"road course" in the description column of table number two. road course is
defined as event number 1 in talbe number one.

You don't.

Table 2 should not "HAVE* a Description column. It should simply not exist!

You're using a relational database (unlike Excel); relational databases use
the "grandmother's pantry principle" - "a place - ONE place! - for everything,
everything in its place". The description field should exist in the Events
table, and noplace else.

Your other table should have the EventID as a link to the Events table. You
would create a Query in the query design window, by adding the Events table
and the other table to the grid; if Access doesn't do so for you
automatically, drag the EventsID from the Events table to the other table's
EventsID to "join" them. Select the Description field from the Events table,
and the Results field from the results table; open the query and you'll see
each event's description together with its results.

If you are using the table datasheet - or even the query datasheet - to
interact with the program, don't. They're not really designed for the purpose.
instead, create a Form; this can either be based on the query, or you can use
a Form based on the Events table, with a subform based on the Results table
(this is the best bet if you have multiple results for each event).

To print data out, use a Report based on a query joining the tables.

 

[Steve Byrd]

I sincerely appreicate the responses. I've just not been successful at
implementing these solutions. Too dumb, i guess. Bought a book on E-bay.
Maybe that will do it.

 

[John W. Vinson]

I sincerely appreicate the responses. I've just not been successful at
implementing these solutions. Too dumb, i guess. Bought a book on E-bay.
Maybe that will do it.

It's a complicated program, and there's a lot to get your head around!

Here are some other resources; Crystal's video might be a good start:

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

Roger Carlson's tutorials, samples and tips:
http://www.rogersaccesslibrary.com/

A free tutorial written by Crystal:
http://allenbrowne.com/casu-22.html

A video how-to series by Crystal:
http://www.YouTube.com/user/LearnAccessByCrystal

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials

 

[Steve Byrd]

Thanks....

I use asp.net querries against Access and SLQ server all day long. You'd
think I could figure this out.

 

[John W. Vinson]

Thanks....

I use asp.net querries against Access and SLQ server all day long. You'd
think I could figure this out.

It might help to think of an Access Query as being analogous to a SQL View.
They're used in similar ways.