Hyperlinks as lookup source

[Paul Fenton]

I have table "Researchers" of names, phone #'s and websites. It's the
lookup table for the "Clients" table that supplies the Names and/or
websites for the Clients table.

The problem is, if I designate a field in the Clients table as
"Hyperlink", I cannot Lookup the values in my Researchers table. The
Lookup option's not available for a hyperlink field.

Is there a way around this, so that I can get the URL into the
hyperlink field of the Clients table>


Paul Fenton

 

[Jeff Boyce]

Paul

It sounds like you are running into problems associated with trying to use
the "Lookup" data type in Access tables. A scan through this newsgroup
(tablesdbdesign) will show a strong consensus against using it, period.

The main argument against using it is that what is stored and what is
displayed directly in the table are two different things, leading to ...
?!confusion!

Besides, tables store data, forms display it. You're probably better off
not working directly in the tables, but via forms. And this would allow you
to use a combo box, based on the lookup table.

Good luck

Jeff Boyce
<Access MVP>