Linking Columns of data to a query in Access

bunyard · Joined: 15 Apr 2006 Posts: 1

Hi! I was wondering if it was possible to link tables within the same data base in a way that when you change a field in one it automatically updates the query? It would really make my job a lot easier if I could link just specific fields in one database so that I wouldn’t have to enter the same data in different tables again and again. Thanks a lot for any help!

willits · Joined: 15 Apr 2006 Posts: 1

I think that I’ll have to disappoint you but the answer is no. You could perhaps write an update query that would keep the columns in line every time you ran it. Of course, this can all be done providing there's some key data that ties rows in the tables together. I suppose this could make it a bit easier for you.

H-Desk.com - PC Security matters - Protect your PC privacy

Linking Columns of data to a query in Access

LIFEFORM SOCIAL COMMUNITY NETWORK