Can one record update several other columns in the same table using relationships
Just a quick heads up.
I've had an MS Access database for a while now for project management and have started to reorganize the tables to make it a true object relational database.
I currently use a Project ID unique key with no duplicates.
I also use the combo box and table/query to choose records for the main table to avoid duplication.
The question is, because the information is pulled from several other tables to populate one row and those records all have a unique Project ID key associated to them, I would like to be able to enter the Project ID (which is also a table/query selection) and have a query locate all the associated links in the rest of the columns in that table, rather than have to manually enter them in again and again.
Is there a way for this to happen?