Simulate Lookup Field Functionality on Data Access Page - Access 2000

Joined
Jun 30, 2005
Messages
1
Reaction score
0
I am a beginning Access user and have built some data access pages for users to view and edit records one at a time. I would like to make some of the fields drop-down lists that call up values in a separate table than the database that the page is bound to, but store whatever value is selected to a field in the database that the page is bound to.

I'm using the NavwithServerFilterfromNumericField function that's in the sample Northwind database, and if I try to add a field that's bound to a table other than the page's bound table, the server filter breaks.

Does anyone have a solution to this?
Thanks!
 
Back
Top