I have a form in Access 97 that will go to the SQL SERVER back end and update a form. However, when I add a second table to the form, the access form unhighlights the add new record arrow. Thus, I can't update the form. The only reason that I reference a second table is that I need to basically translate out a person's employee # and give there name. Thus, the name is read only and doesn't need to be updated at all (employee's name is that second table. How can I reference the employee's name in the form?
BTW, my form is controlled by a query that uses the link table from SQL.
Thx
BTW, my form is controlled by a query that uses the link table from SQL.
Thx
