How to display the referenced value of a FK on bound forms

[Corey-g via AccessMonster.com]

Hi All,

I'm pretty sure this is easy, and that I've done it before, but it's the end
of the day and apperently I can't think straight... ;-)

I have a form bound to a table that has foriegn keys (and who doesn't). I
would liek to have those fields display the referenced values rather than the
associated ID's. Now, I could create a query instead of using the table, and
I think that the DLookup function is also used, but I read that using the D
functions is a bad idea...

Using A2K3...

Anyways -thanks

Corey

 

[Dirk Goldgar]

Hi All,

I'm pretty sure this is easy, and that I've done it before, but it's
the end of the day and apperently I can't think straight... ;-)

I have a form bound to a table that has foriegn keys (and who
doesn't). I would liek to have those fields display the referenced
values rather than the associated ID's. Now, I could create a query
instead of using the table, and I think that the DLookup function is
also used, but I read that using the D functions is a bad idea...

Using A2K3...

You wouldn't normally use DLookup for this. One way to do it is just to
include both the main table and the related table in the query, joined
on the foreign key field, and then include the desired field from the
related table in the query along with the fields from the main table.