I'm sorry, What is not happening is it is not seeing new clients I added on the clients side. So it only works with the original three I put in. I've just been staring at it so long I can't remember the current problem.
Your are right. I does create a record with the original three "clients" but when I enter a new client it is not picked up in the dropdown in events so I can't chose them. I misstated the problem in my original post because I have just starred at this for two full days. Thanks for looking at it and any advice you might have.