Select Distinct Query causing data entry not permitted

[Samantha]

I have a datasheet form that is based on a query. The query is based on three tables. Data entry worked fine with this configuration. There was extra duplicate lines that were identical cause by a multi-select box. It seems that once I entered Select DISTINCT that's when it would no long allow new entries judging by my backups. I check the properties of the form and found that data entry had switched to No. I changed it back to yes but the form will still not allow me to add new records.

Any thoughts?
Samantha

 

[boblarson]

Yes, you can't use distinct. But what you really need to do is change to using ONE table for a main form and then use SUBFORMS to handle the other tables. That would be the more correct way to do it especially with one-to-many or many-to-many relationships.