Lookup field in table

G

Guest

Is it possible to code the lookup properties of a field to get values from
another databases table?

I am trying to lookup data from the SchoolsDB, tblSchool field.

Thank you.
 
G

Guest

I would just link to the tables in other database and run a query or use a
form's ControlSource to lookup/edit the data.

File -> Get external data -> Link tables, then browse for the other database
and select the tables to link.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lookup Field Issues 23
Establishing relationship necessary with lookup table? 3
Lookup Field 1
Bound/Unbound lookup field 4
Table concatenation in Relationships Screen 6
simple address db question 4
Access Command button to look up and copy data from a query to a table 0
Allow Multiple Values check box not showing up 1

Top