Lookup question

[gtobey]

I want to update various columns in a single table with developers names as the item represented by the row moves through various stages of development. I'm using a combo box dropdown, on a form, to select the individuals name assigned to that phase. I want to use the same name lookup table for all columns. When I use the Lookup Wizard to add the lookup to the 2nd column, however, Access keeps changing the base table column to the lookup table column name. In the short term I've cloned the names in the lookup table into multiple colums with different names, but this is really kludgy. What am I doing wrong?

 

[RickSpr]

I can't quite follow. Do you have a separate table with developers' names in it, which you would use as the Row Source for your combo boxes? You do have multiple combo boxes, one for each column you want to update, don't you?

It would help if you would provide names for the tables and relevant columns, and identify which columns are used in the Control Source properties of the combos. It's hard to figure out which table you're calling the "base table", for instance.

And did you really mean that Access is changing the base table column to the lookup table column name? Or did you mean the name from the lookup table column? The latter is what you'd expect it to do, isn't it? Rick Sprague