Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
DISTINCTROW query prevents editing of related fields
I am trying to edit tbl_plants.spacing_ID It appears that whenever I use these query results I cannot edit any related fields in tbl_plants. Is there any way around this. From the user end my goal is to have form with a list of 'used plants' and there parameters so that the values in...- thuja
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
DISTINCTROW query prevents editing of related fields
Here's a problem from an incipient revegetation planting calculator... I want to query a list of only those records from [plant_list] that are found in [template_cover]. There may be many entries in [template_cover] for each in [plant_list]. BUT I want to be able to modify the values of...- thuja
- Thread
- Replies: 3
- Forum: Microsoft: Access Queries and JET SQL
