Targets primary key = autonumber (ie 1000587)
Campaigns primary key = autonumber (ie 1257)
Mailings primary key = (Campaigns PK + Targets PK)

Yup: I'd buy all that. If you already have identifiers for the people or
for the campaigns you (might be) able to use those rather than
autonumbers, but it comes essentially to the same thing.

Campaigns primary key = text len5) "GU502","GU503",etc

would be ok if in current use?


Tim, thanks for all your help.