Updateable Query

[poporacer]

I have a form that I want to be populated with bound textbox controls. The record source for the forms is a query and I believe my problem is that the query in not able to be updated. To get the query I have a table (TablePositions) that has FacilityID as one of the fields. I then have another table (TableStaff) that has names and a foreign key to facilityID. I need to get the list of FacilityID's from TablePositions. There are several occurrences of FacilityID in TablePositions so I need to join the two tables but as soon as I use a DISTINCT for the FacilityID, then the query is not updateable. So I tried a different approach, I created a query just to get the DISTINCT FacilityIDs from TablePositions and then LEFT join this query to the TableStaff. But this query is not updateable either. Any suggestions?

 

[RuralGuy]

The list in this link should help you: http://allenbrowne.com/ser-61.html

 

[Pat Hartman]

By using the DISTINCT predicate you are asking the query to aggregate data. When you do that, the individual records loose their identity and that makes the query not updateable. You may be able to solve your problem by using a form with a subform so that the main form is bound to a query of the parent table and the subform is bound to a query of the child table.