populate field from another table

[CAM]

Here is what I would like to do. I have table 1 that has 4 fields (station,
temperature, salinity, and depth) that are also in table 2. Table 1 has a
bunch of other data in it and I don't want the person entering these new data
to have write permissions on 1, which is why these fields are the only ones
in table 2. Is there a way that I can automatically populate the fields in
table 1 from table 2 based on the uniqueID station that is in both. I know
that I can do an update query, etc., but I'd rather it happened
automatically. The fields have been in table 1 a long time and have just
been blank, so people have lots of queries based on this table and I would
rather they don't have to link a new table and add it to their queries to be
able to access these fields that are finally being entered. Can anyone help?

Thanks
cam

 

[Tim Ferguson]

Table 1 has a
bunch of other data in it and I don't want the person entering these
new data to have write permissions on 1, which is why these fields are
the only ones in table 2.

Bad solution.

Better solution: remove all permissions for users from Table1. Create a
query, with yourself (admin) as owner showing just the PK and the
appropriate fields, and mark it Run With Owner Permission. Give the the
users read/ write permission on the query and they will then be able to
access these fields but not any other ones.

And do away with the other table, because it will compromise your data
integrity.

Hope that helps


Tim F