Lookup Field

[Guest]

Hi!
Using the wizard, I can create LookUp fields in my form, within the current
Access database.

However, I would like to create a LookUp field or column that will provide
information from ANOTHER Access database. Is this possible? If so, how do I
go about doing it?

Thank you!

 

[Dirk Goldgar]

Hi!
Using the wizard, I can create LookUp fields in my form, within the
current Access database.

However, I would like to create a LookUp field or column that will
provide information from ANOTHER Access database. Is this possible?
If so, how do I go about doing it?

Thank you!

I'm no fan of Lookup Fields (as established in the table design), for a
number of reasons. However, to do what you want you can first create a
linked table, linked to the table in the other database, and then build
your lookup field referring to the linked table.

 

[Guest]

Thank you SO MUCH!!! It works!

I'm no fan of Lookup Fields (as established in the table design), for a
number of reasons. However, to do what you want you can first create a
linked table, linked to the table in the other database, and then build
your lookup field referring to the linked table.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)