I am a newbie. I am building mutiple tables/queries in one form. I got it to work but it is duplicating records where a name appears more than once. How can I stop this.

Regards

Sounds like you have a One-to-many situation and you should be using a main form for the ONE and a subform to capture the MANY side of things.