Michel

I think you are telling me to join to the other table to display some of
it's columns, but actually I'm using the lookup to support a foreign key
contraint and limiting the user to valid keys from the other table.  It also
helps when you can show the name of the item instead of a record ID number
when the user is creating the linkage.  You can't show the data from the
other table until you have the pointer (foreign key) set.

Really this problem is only a minor annoyance, but I was hoping to report it
so maybe Microsoft could fix it in a future release.  It's frustrating to
have your work trashed without warning.  They may or may not fix it, but if
nobody tells them they won't fix it for sure!

If you go to the MSDN Product Feedback report bug page, they list most of
the other development tools.  I was wondering if there was another page
specific for Access, because Access does not appear in that product list.

Thanks for your help.

Bill