Lookup data in Oracle and move to new record in Access 1

[Basia]

Here is what I want to do. I have linked four tables from our Oracle database which contains up-to-date employee information. In Access we have a small database tracking employee parking spaces. What I want to do is have the user add a new record by typing in the last name of the employee with a pop-up or subform come up listing all employees with that last name and then have the user click on the correct record and those fields moved over to the new record.

Are you still following? Oracle is not so friendly in letting the user choose the correct record.

Any help is much appreciated.

Basia

 

[Amiel]

If using the Oracle tables is prohibitive for performance reasons; you might create a local table (in Access) and fill it with the necessary 'look up' information.

Are we talking looking up First Lame, Last Name type stuff ?
You'll have to be the judge, but to fill a recordset with a couuple of thousand records prior to filling the list box, or perhjaps prior to displaying the form while delaying the program for a few seconds makes makes sense. Amiel
amielzz@netscape.net

 

[Basia]

Thanks for the tip. It works. Now do I have to figure out how to hard code the oracle ODBC password. Any thoughts?

Basia