I have a database that uses both front end and back end tables. We need to pull data from read-only back end tables and supplement it with 'local' information. I'd like users to be able to update front end tables while also seeing the back end tables. Is there a way to create a query that combines back end and front end tables and still update the front end fields (all attempts so far are not updateable)? I considered using subforms as a work around, but would like to use a query if possible. Thanks.
<img src=/S/confused3.gif border=0 alt=confused3 width=45 height=45>