I do have a query that joins several tables. It works fine but there are two tables that are join by fields that have a different name. One table contains a field called Emp_Number and the other table (It is a link table from another department, used in many places therefore is not feasable to change the name) have a field called Emp_ID that is part of a compound index. The problem is that every time I save the query and I open it later in the design mode the link had disapeared. Do anyone know why this is happenning and how could I solve this problem?
Thank you
Thank you
