If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
populate field from another table
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 |
#2
|
|||
|
|||
=?Utf-8?B?Q0FN?= wrote in
: 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Get data from combo box to popluate the next box | Lin Light | Using Forms | 4 | December 30th, 2004 05:01 PM |
transpose | john | Using Forms | 1 | November 24th, 2004 06:16 PM |
Name not showing ID is | René | Setting Up & Running Reports | 11 | June 29th, 2004 01:40 AM |
Newbie? Do I use Report or Query | John Egan | New Users | 11 | June 28th, 2004 08:31 PM |
COMPARE THE TWO TABLES | Stefanie | General Discussion | 0 | June 4th, 2004 04:36 PM |