Populating forms for data entry

[djdeuph]

Hi all,

I have two tables - one is linked to a SQL database and the other is my local Access version. I need to create a form that will allow a lookup of the available info in the linked table to ease data entry in the local table.

Example:

I have employee info for a parent company. These employees also work for the subsidiary. I also have employees who only work for the subsidiary company. I only have read access to the parent company db. This necessitates having my own employee table. In order to decrease the amount of data entry, I would like to be able to choose from parent company employees on my form or add new records (if they are parent company employees). Choosing a parent company employee from a dropdown box would populate all of the other fields on the employee form.

Any ideas on how to set this up?

 

[SirWaldizmo]

Do you have privileges to connect to that db via ODBC?

 

[judgehopkins]

Ask whoever has the administrative privileges for the parent to export whatever tables, etc. you need.

I have done this before and it worked great for me....

Judge Hopkins

"...like hunting skunks underwater...."
John Steinbeck, The Grapes of Wrath