Problem with Select DistinctRow

[bgus]

Am having a Select DistinctRow recordsource problem.



I have 2 forms and a subform
1. Form Attendees (one to one) has a control button that calls
2. Form Registration (one to many)
The data from Registration should show up on the
3. subform on the Attendees form.

The subform properties has a SelectDistinctRow statement under Record Source that has extra tables/fields in it that used to be in the database template but that I took out of the relationships table. Here is the statement but I don't know how to modify it:
SELECT DISTINCTROW Registration.RegistrationID, Registration.Confirmation, Events.EventName, Registration.AttendeeID, Registration.EventTypeID, Registration.JobTypeID FROM Events INNER JOIN (Registration LEFT JOIN [Sum Of Payments Query] ON Registration.RegistrationID=[Sum Of Payments Query].RegistrationID) ON Events.EventID=Registration.EventID ORDER BY Registration.RegistrationID;


If anyone can assist w/the correct SELECT DISTINCTROW statement, that would be great.


Attached are bmps of

• Attendees table showing the subform #3 above
• current relationships table
• design view of Relationships form that the attendee form calls (and the data from which feeds into the subform)

I am not sure how else to show the database. Is there another way to export a simplified version of the db to post to the forum?


TIA for any help.

Betsy

[bgus]

The attachments either exceeded the dimension or kb size limitations. Not sure how to communicate the problem. Suggestions welcomed. Thank you.