Distinct and Updatable dynaset

[niteraven]

Hello All

I have searched and cannot find the answer to this question. I made a query based on two tables. I can update anything inside of this query only when i take out the word DISTINCT.

What i want to be able to do is give the user the ability to choose a procedure type and view all of the clients under that type in a form and choose to whom they will print a label for.

SELECT tblvisits1.prodtype, tblpatientinfo.Last, tblpatientinfo.First, tblpatientinfo.Address, tblpatientinfo.City, tblpatientinfo.State, tblpatientinfo.Zip, tblpatientinfo.inactiveclient, tblpatientinfo.nosnailmail, tblpatientinfo.printlabel
FROM tblpatientinfo INNER JOIN tblvisits1 ON tblpatientinfo.patientID = tblvisits1.patientID
WHERE (((tblvisits1.prodtype)=[forms]![frmprodprint]![prodpick]) AND ((tblpatientinfo.inactiveclient)=False) AND ((tblpatientinfo.nosnailmail)=False));

tblpatientinfo has one to many to tblvisits

This query will not allow me to update information (within query and within form)

ANy help would be appreciated, thanks
Raven

 

[PHV]

Have a look here:

http://support.microsoft.com/kb/148581

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[niteraven]

I have read this already and cannot find the answer. I tried distinct row and it gives me the client name for each record within the tblvisits (which is updatable, but is duplicating the client name). I need only to view the clients name once in a form based on what procedure type they have had done, so the user can choose whom to send a flyer to.

ANy help would be appreciated.
Raven

 

[PHV]

Why not using a classical main form linked to a subform ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886