Auto-Fill Fields based on Linked Table (Access 2007)

[LWoods]

I understand right off the bat if you're reaction is "don't duplicate data!!" -- mine would be too (don't fret, I know my normalization).

I've linked a table in my db to my Global Address Book in Outlook 2007 and, upon entering an employee number as a new record, would like to verify that the number entered is listed in the GAL and then pull in the associated name and location info.

The key is that I don't want this info to rely on the GAL going forward. For example, if an employee leaves or is no longer listed in the GAL, I don't want to lose the employee info (past data is needed for audit purposes). Note: I will be creating a report later to show if there are discrepancies between the GAL and my table, but that's another story...

So, what would be the best auto-fill options in Access 2007?

 

[pbaldy]

In a form I'd do this:

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

 

[LWoods]

Thanks so much pbaldy! Saw this link in another post, but hadn't read down to the rare situation part. Sorry for the unnecessary thread!

 

[pbaldy]

No worries, happy to help!