Way for preventing Blank and Duplicate Records

Hi everyone,

What is the recommended way to prevent blank and duplicate records?

please give me some solutions??

Thanks

Set up referential integrity using indexes. You can have autonumbers but have multiple field indexes so you don't end up with duplicates.

But, if you set a field to be required then it will not allow you to save without it. Sometimes that might not be good, depending on your workflow, but you should be able to also validate in your entry forms (providing nobody is accessing the tables directly).

what would happen?
If I set up multiple indexes and someone tries to enter a duplicate.

Via a message box it tells them that they can't enter that as it would be a duplicate and then it doesn't fill in the last part of it and waits for them to try again.

If you need additional assistance on creating a multi-field index - here's a visual:

http://www.btabdevelopment.com/main/...0/Default.aspx