Return data

[halmeida571]

Hello,
I need some help from you. I'm trying have a query with to tables and a link form (DlookUp):
In this form i have a [field y] from [table x] that i can choose from a list the employee name, but when i choose a name i need that a [field a] from [table b] will be automatically update returning the login of this employee name. In data source of this form have query with [table x] and [table b].

Kind regards
Helena Almeida

 

[pbaldy]

I'm not clear on your layout, but it sounds like this might fit:

http://www.baldyweb.com/Autofill.htm

Typically a form is bound to a single table.