Relationships & Forms 2007

SueB77

New member
Local time
Today, 07:32
Joined
Jan 24, 2012
Messages
7
I created two tables. They have a relationship, which I need. However, when I pull up my form for the first table all records will not show. The only records that show are the 2 with relationships. It is making me crazy!
Thanks for any help you can give me.
 
I created two tables. They have a relationship, which I need.
I hope this relationship will last Sue :)

However, when I pull up my form for the first table all records will not show. The only records that show are the 2 with relationships. It is making me crazy!
Thanks for any help you can give me.
So you mean when you open the query where these two tables are linked together?

If you want ALL records to be pulled from one of the tables, you need to change the Join Type. Right click the join between them and make that change.
 
I hope the relationship last as well. It is between our Mentors and our Mentees! lol

I tried what you suggested. I changed the join properties from 1: to 2:Include ALL records from 'Mentee' and only those records from 'Mentor" where the fields are equal.

This should have done it. But instead of 4 records showing only 2 are. :mad:
 
Well, I guess you have some criteria in your query that's not allowing it work.
 
Well, yes you are probably right. Except I don't know how the criteria got there or where to find it! (Yes, I AM a newbie)

I just did another quick form to see if all the records showed up. Sure enough. The probelm is I have worked so hard on tyhis form I would rather not just totally re-do it.

Where can I see if I have specified criteria?

And FYI thank you VERY much for the replies to this post.

My Access 2007 book is shipping from Amazon as I type this! :rolleyes:
 
It's a query you're opening right? Right-Click the query and select SQL View. Copy and paste the SQL statement here.
 
No, it's a form. I have created a form for inputing data into the tables. I have 4 records but only 2 (the one with relationships) are showing.
 
Open up the property sheet of the form and tell me what's in the Record Source property which you will find in the Data tab.
 
SELECT Mentee.*, Mentor.[First Name] AS [First Name_Mentor], Mentor.[Last Name] AS [Last Name_Mentor], Mentor.[First Name] AS [First Name_Mentor1], Mentor.[Last Name] AS [Last Name_Mentor1] FROM Mentee INNER JOIN Mentor ON Mentee.[Match ID] = Mentor.[Match ID];
 
Well, you hadn't changed it Sue :)
Code:
SELECT Mentee.*, Mentor.[First Name] AS [First Name_Mentor], Mentor.[Last Name] AS [Last Name_Mentor], Mentor.[First Name] AS [First Name_Mentor1], Mentor.[Last Name] AS [Last Name_Mentor1] 
FROM Mentee [COLOR=Red]LEFT JOIN[/COLOR] Mentor ON Mentee.[Match ID] = Mentor.[Match ID];
Paste the above there and run it.
 
I could just jump right through this screen and hug you!! But I went into to the relationship and chode the #2 option. Oh my, thank goodness for epople like you helping people like me!
If it makes you feel better I am employed by a non-profit that helps kids in foster care as well as has a mentoring program. We can't afford the software so I am developing a database. And YOU, my friend have helped me a lot!! Thank you again.
 
That's what we're here for - to help people like you!

Happy to help Sue!
 

Users who are viewing this thread

Back
Top Bottom