Hello all!

I feel like I'm very close to figuring this out, but can't seem to get past one point.

I have 3 tables. Items is a one to many relationship with SH, and Patron is a one to many relationship with SH. I'd like to use a form (either with or without subforms) as the main data entry method. The form is based on a query of all three tables. The main part of this form should be the fields from SH, but I want to be able to input the Items and Patron information from there as well.

The problem is, when I use the Items or Patron key in the form (or subform) it tells me I'm duplicating values in these tables. I don't want to create another record for the same thing, all I want is to display the info on the item or patron that already exists in connection with the info from SH.

I know this seems backwards from all the sample databases, but for this form I don't want to see one Item or Patron and all the SH records associated with it at one time (like Orders-Order Details in the MS sample database). My main focus is the info in SH, one at a time.

I'm sure I'm missing something really basic - can anyone help me out? Much appreciated.