Greetings!
I currently have a table for salesman call tracking as follows:
tblMaster
MasterID autonumber (unique ID)
SalemanID longint (FK to salesman table)
CallDate date (the date the call was made)
<other info fields>
I have a no-duplicates index on MasterID, I have duplicates-ok indexes on SalesmanID and CallDate. Plus, the combination of MasterID, SalesmanID, and CallDate is the primary key. What I'm trying to accomplish is to prevent entry of two records with the same SalesmanID and CallDate. From what I've read in the help file I thought setting it up as above would accomplish this, but it doesn't. If I make the SalesmanID index no-duplicates, then it won't let me enter two records with the same Salesman ID even if the call date is different. Ditto on making the Date index no-duplicates.
I think I know how to do the same thing with VB validation code tied to the events in the data entry form I've created for this table, but I'd rather handle it at the table level if I could.
Any ideas greatly appreciated!
Dale Beitz
I currently have a table for salesman call tracking as follows:
tblMaster
MasterID autonumber (unique ID)
SalemanID longint (FK to salesman table)
CallDate date (the date the call was made)
<other info fields>
I have a no-duplicates index on MasterID, I have duplicates-ok indexes on SalesmanID and CallDate. Plus, the combination of MasterID, SalesmanID, and CallDate is the primary key. What I'm trying to accomplish is to prevent entry of two records with the same SalesmanID and CallDate. From what I've read in the help file I thought setting it up as above would accomplish this, but it doesn't. If I make the SalesmanID index no-duplicates, then it won't let me enter two records with the same Salesman ID even if the call date is different. Ditto on making the Date index no-duplicates.
I think I know how to do the same thing with VB validation code tied to the events in the data entry form I've created for this table, but I'd rather handle it at the table level if I could.
Any ideas greatly appreciated!
Dale Beitz