"Steve" wrote in message
...

You need a form/subform for entering data. Base the main form on
TblPerson. Base the subform on TblMeritBadgeAward. Set the LinkMaster and
LinkChild properties to PersonID. Use a combobox in the subform to enter
MeritBadgeID. Your form/subform will display a single person and a list of
merit badges awarded to that person. You can sort the merit badges in
alphabetical order. Now all you need do is rely on the data entery person
not to enter a duplicate merit badge for any person.

Steve


You forgot the part about chastising the poster for his table design and
that only you can help him --- for a fee.

John...