I have a database that has different types of insurance plans listed in a datasheet, and each plan can have a combination of different plan category, plan type, coverage type. But I want each plan to be unique, so there aren't two plans with all three fields having an identical value.
Here is a link to the example DB for clarification and so you can see the relationships and table structures:
http://home.comcast.net/~sbingier/db/plans.mdb
The problem I am having is that when I go into datasheet view on "sfrmPlan", and I try to make a new entry, I get an error that says "The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship..."
I'm stumped and can't figure out the solution. Thanks in advance for the help.
Here is a link to the example DB for clarification and so you can see the relationships and table structures:
http://home.comcast.net/~sbingier/db/plans.mdb
The problem I am having is that when I go into datasheet view on "sfrmPlan", and I try to make a new entry, I get an error that says "The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship..."
I'm stumped and can't figure out the solution. Thanks in advance for the help.
