Lookup tables in Microsoft access (confusion?)

Row source should be Table / Query and not Field List.

You should be doing your lookups in a form and not in tables. Look at this link to understand why.

http://access.mvps.org/access/lookupfields.htm

then look at this video on how to set it up in a form.

http://www.datapigtechnologies.com/f...combobox1.html

Originally Posted by alansidman

You should be doing your lookups in a form and not in tables. Look at this link to understand why.

http://access.mvps.org/access/lookupfields.htm

then look at this video on how to set it up in a form.

http://www.datapigtechnologies.com/f...combobox1.html

This may be true, but if I can't get the desired result in a table then i'm never going to get it right in a form.

My knowledge is slowly improving on this, but I'm having trouble getting a particular result.
If Table1 has an ID column the same as the ID column in Table2, then shouldn't I be able to replace(lookup), say, the Field2 Column, in Table1 with the Field2 values in Table2.

So in doing this, the Table1 Field2 would be displaying Table2 Field2 values like any lookup.
Without using the wizard, how do I do that? The ID column should serve as a common value to do the lookup against.

I realize I would choose the below settings
Display Control: Combobox
Row Source Type: Table/Query
Row Source: This is where I get stuck in achieving the result I want.
Bound Column: 1
Column Count: 1





Table1
tbl1.png


Table2
tbl2.png

I have managed to create a lookup field between these two tables.
I thought that when I create a lookup field in my Table, that column should display the looked up values? Why would my table not be doing this?

According to the Access 2002 Bible this is what should happen. (I'm using Access 2010 by the way).

I should be able to view the table i applied the lookup to in Datasheet View and see the looked up values in their respective column.

Why is this not happening?

Here's a screenshot of my lookup properties.

Even when I change the Bound Column to 2 I can only see the old values. Not the looked up values?
properties.png

Your post does not comply with Rule 8 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).


crossposted: http://www.accessforums.net/showthread.php?t=58522

An thus, still no attempt to help with the issue!