Hi Pam,

Not sure I understand, but that's fine.

My advice for your new design (in the area visible in this discussion) is
that each record in each table have a UNIQUE (never ever to be repeated, and
never, ever to be changed once it is in) identifier (= Primary Key) for every
record in every table. In your case, to assure that "external" forces will
never have the "hooks" for force to you violate "never ever change or repeat
it", make it an internal number that nobody ever sees, and which has no real
world meaning.

Sincerely,

Fred