Also --- one more thing. What relationships need to be done to have employee F & L names go into other tables when I enter on my main form?I'm sorry ....I'm back. I like associating with you because you've helped me more than you know. I changed my relationships and primary keys in my forms today due to having trouble entering new staff who I haven't received theer employee # yet(there's a lag time) so I changed some PK from that still had employee # as PK. I'm adding new staff in all my forms-everything as far as I can see - is working. However, when I tried to recreate my queries that I had before redoing my Main Employee table when changed PK is not working. So I know it something I did when I changed PK form my tables. Will you please look at my relationship diagram and let me know what I need to do to fix it so I can run queries when needed.