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