var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: SQL Query with associative table
Here is a screenshot of the relationship window for what i am talking about:
What i would like to do is the following:
By clicking a button in the form when the current record is a Player, a report will pop up giving information related to that players parent. This information should be address, phone and email.
I know how to do program a button to display a report for that specific Member. For this it will be:
Private Sub ParentInformation_Click()
Dim strWhere As String
strWhere = "Members.[Member ID] = " & Me.[Member ID]
DoCmd.OpenReport "Players Parents", acViewPreview, , strWhere
I am however, very confused on the SQL statement that will give me these results.
My current query, which is totally wrong is:
SELECT Members.[Member ID], Members.[Last Name], Members.[First Name], Members.[Street], Members.[City], Members.[State], Members.[Zipcode], Members.[Home Phone], Members.[Email]
WHERE EXISTS (Select * from Parent_Player where Parent_Player.[Player ID] = Members.[Member ID]);
anyone familiar with writing queries for associative tables that could help?