|
RE: MS Access question: Lookups
What you need to do is create a select query which will output the names and the ID fields that you need. Then go back into the form designer, add a combobox, go through the wizard that pops up, choose the query you just made and then go through the rest to wizard to finish making it appear as you wish.
The only part I'm not 100% sure on is the saving part (which is an option in the wizard also), although there's probably information on that in the help (which I don't have handy at the moment).
![[Image: favicon.ico]](http://trekie.net/favicon.ico) Jonathan Kay
Note: I am not Dutch, but not from lack of trying  | 
/ 
