Greetings,
I have Access 2007 and Microsoft Sql Server 2005 standard.


I have two databases on the sql server. I need to create front end form to add/update/delete data from the database. So in access I created a form. I then created a linked table to a table in database1. I then created a 2nd linked table to a table in database2. Set forms data source to linked table1. I want to have a text field on the form that shows the description from linked table2. So
Database1-> table1->item-field, ship date Database2->table2->item-field, item-description.

when database1->table1->item-field is shown on the form, I want database2->item-description to be displayed.

how do I do this?