Indexing (no dupes) dates where employee code = XXXX

[snipe]

Hey guys,

I have 1 master table that holds all of my company's 200+ sales associate's pay roll data. I have built an entry form that works great, but I want to make 1 tweek.

When you open up the entry form, a subform shows the data for the past 6 pay periods for the selected salesperson. This pulls from the master table as well. I want the entry form to not allow a date to be entered twice. The catch is, that if for Salesperson A I have entered his payroll data for pay period 11/17/13, I have to be able to enter data for the same week for Salesperson B, so just setting that field to indexed(no dupes) wouldn't cut it. So, I want dates to not allow duplicates, while a certain salesperson is selected.

I hope I explained that well enough.



Thanks guys!

[June7]

Could try a compound index using the date and salesperson ID

[snipe]

Details? Makes sense, each salesperson can only have 1 date. How do I do this?

[June7]

Does this help http://office.microsoft.com/en-us/ac...010210347.aspx

[snipe]

Awesome! I had the indexes already set up. I had no idea about the multiple-index method of not naming the second index.
Good to know.
Thanks June7!