Preventing Duplicate Data Involving 2 Values

[EdaxFlamma]

Good afternoon all,

I am currently working on a form portion of a database that tracks how many clients come to specific events.

The structure is as such:

tblClient
ClientID
ClientFirstName
ClientSecondName
ClientAddressID
Etc.



tblSocials
SocialID
SocialHostID
SocialDate
SocialLessonSubjID
Notes

tblSocialPatronList
SocialPatronListID
ClientID
SocialID
ClientSocialPrice

My issue is that currently with my form set up, I can enter a client into the subForm based on tblSocialPatronList more than once for the same event. Is there an easy way to control that while still allowing the same patron to be available for multiple social events?

Thanks for your help,
-J.P.

[June7]

Simplest and easiest is to set a compound index on ClientID and SocialID fields in tblSocialPatronList.

[EdaxFlamma]

June7, thanks for the quick reply; I'll check that out now. I knew there had to be a way but I just didn't know where to start.

Thank you again. If I get stuck I may try to pick everyone's brain once more.

[EdaxFlamma]

Update: We are solved. Thank you very much for your help.