Update duplicate checking

[orange]

What you have may work, and I'm not trying to discourage you. You told me that

You deal with Cases
Each Case has a number
A Case can have 1 or more Files


Users/Customers borrow Cases

I'm not sure how to interpret your Records table. But it is not normalized.
Normalization and table structure will help with your navigation -- a whole bunch.

[bigderon88]

I don't feel discouraged, I feel you are enlightening.

I am not sure what you mean by normalization. My application is simple, just alot of fields in the table. Here is my add/edit form. Really the only thing we use besides various reports or queries. Maybe this will help you interpret better.

[bigderon88]

That case showing may contain only one file, in that case a borrower would get just that, one file. However, it may contain 2 files, or 4 or even 8, but all the files are attached to that case number and therefore are truly only a part of 1 case 'file'.

[bigderon88]

Here it is. Sorry.

[orange]

I am not sure what you mean by normalization

.

Once you get an understanding of Normalization, you'll appreciate database a lot more.

Here are some links to videos and site that should help. These are geared to database design.

http://www.youtube.com/watch?v=IiVq8M5DBkk Logical data modeling

http://www.youtube.com/watch?v=BGMwuOtRfqU Candidate key

http://www.youtube.com/watch?v=ZiB-BKCzS_I Normalization

http://www.youtube.com/watch?v=pJ47btpjAhA Normalization example

http://www.youtube.com/watch?v=q3Wg2fZENK0 1st Normal form

http://www.youtube.com/watch?v=vji0pfliHZI 2nd Normal form

http://www.youtube.com/watch?v=HH-QR7t-kMo 3rd Normal form

http://www.youtube.com/watch?v=q1GaaGHHAqM E_R Diagramming

http://www.youtube.com/watch?v=lXAGQ8vmhCY ERD Part 2

See What is Normalization here also.

The first few topics are well worth the read.

http://www.rogersaccesslibrary.com/forum/topic238.html

For help with access generally, this link has been referenced often
http://www.accessmvp.com/strive4peace/ Lots of Access Syntax, rationale, samples etc.


Good luck with your project. If you want to pursue further, just post.