I have switched to my database, but my forms and reports will not work, my child is permit, my master is site. I want to access the permits, in permit order by permit #. The relationship is by site ID. All my records show up with the same site info as I flip through the permits. It doesn't seem to understand the relationship. What am I doing wrong. I must be able to edit and update the permit info. You said that I should do a view, but will I be able to update/add site? I am not able to carry the information from screen to screen. Must I define a the key as a Global variable or something? If I sound confused, I AM!