Tom, thanks for replying. I see what you're saying about having the lease number being the primary key. I tried changing the one to many relationship to be through the lease number, but the problem is that the lease number is not completely unique...it should be, and is for the most part but...