I'm new at this and just starting out. I have the database up and running with my fields. I am wondering if I can create a check that checks the date of the appointments before the record is added to let them know that the time is taken. you can look at it at www.qualityautogroup.com/cgi-bin/dbman/db.cgi
If I am not clear enough for you to understand what I am looking for you can give me an e-mail Briank@mwweb.com
Brian

In the FAQ noted below under the section for "Fields" there are several thread references for checking for duplicate records.

Check out "Prevent duplicate entry in field", which may be what you are looking for. If not, there are some other options.

Hope this helps

Unoffical DBMan FAQ
http://webmagic.hypermart.net/dbman/