Recent content by SueB77

I have created a form and am trying to insert a lookup field. I can actually get it to pull the correct information from another table. However, the lookup displays first and last name (two separate fields) for my choices. I choose the one I want and it only inserts the first name into the form...

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...

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];

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.

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...

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...

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.