Search results

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