Probably Easy ... check if record exists based on multiple values

This is probably another really easy thing that I am over thinking. I know how to validate and prevent a database insert if a record value exists. Works wonderfully.

Now, I need to check two fields in the same record.

Field One: Program Name
Field Two: Client ID

Client can be in the table many time, and program name can be in the table many times. What I need to prevent is Program name and Client ID from being entered again in the same record. So no two records can have the same Program Name and Client ID combination.

Hope that makes sense. I am sure it is easily done and I am just over thinking it and it’s too early for a beer.

Community Page
Last updated: