I have created an Access database for inventory control. It is linked to a AS400 database. The problem is after linking it doesn't recognize the properties. Example: Required is "Yes", Indexed is "Yes (No Duplicates). It is not acknowledging the commands. I am trying to write a code on the form to prevent duplicating on 3 different fields. NO LUCK. All my books just refer to setting this up in the table. I need to set it up in the form. Sure hope you have an answer.
Thanks!

These rules need to be defined in the database on the AS400. The ODBC driver may not properly display certain attributes of a table, but the backend RDBMS will not accept updates that violate any data integrity constraints that were defined for it.

I thought I could could write a code in the form (VB) to show a msgbox when there are duplicates. Have you ever done that before? If so, please tell me how.