I have a form that gathers information from 3 tables. I also have a form to enter a new record into those tables. I have default values set for 2 of the fields (from separate tables) so that when I create a new record, those 2 fields are automatically set to show what I want.
When I try to save the record, a screen pops up and says I need to change the index to allow for duplicate values, but in the table properties for these fields I have Indexed set to Yes (Duplicates OK)... So I am confused about why this screen is popping up.
Any help is much appreciated!
Thanks
Dan B.
When I try to save the record, a screen pops up and says I need to change the index to allow for duplicate values, but in the table properties for these fields I have Indexed set to Yes (Duplicates OK)... So I am confused about why this screen is popping up.
Any help is much appreciated!
Thanks
Dan B.