My database contains many one to many relations ships that share fields. Example one employee list can be used as a dropdown for several other fields. When I build my queries I only want to see the value in the list that applies to a specific field. So in the query window I removed the realtionship to the other fields to get my results (they were correct.) However, when I close the query and reopen it several of my fields have been changed to expressions that refer to the wrong fields and many of the one to many relationships have been changed to one to one relationships. I am not sure if there is a problem at the table level or if it is at the query level. If any one can help I would be very greatful.