So confused!!

[nexshark]

I need to set up a database that has documents linked to it. I do not know VBA, SQL, etc. Just fighting thru Access wizards and tutorials.

I have Fields in tables as follows:
Table 1--Documents
Doc ID (PK)
DocTitle
DocType
DocLink

The documents, many of which are legal depositions, in many instances have Exhibits attached in the form of other historic documents, and even some other depositions (I havent even started considering how to deal with that yet) which I believe therefore have a many-to-one link to the Doc Table.

Exhibits
DocID (FK)
ExhID(PK)
ExhTitle
ExhLink

All have persons attached (many-to-one relationships with and Doc) and many have legal cases they belong to...I eliminated a separate Case Table to try to simplify up the relationships and hotry to get the forms/subforms to work...


LastName
FirstName
Expertise/Standing
Person ID(PK)
CaseName
CaseState
DocID (FK)

As you might guess, I am having trouble setting up forms(subforms?) for data entry. I have asked questions on the forum about specific problems I was having, but more and more I see my entire logic may be failed here... ANY help would be appreciated.

 

[Fifty2One]

If you have already thought through the table relationships then you probably have the answer already but are running in circles... happend to me lots some days...
Maybe you just need to get a cup of coffee, close your office door, get out the pencils and paper. Scribble it out the form with the field names and source and rearrange them slightly to make sense to both the end user and your table relationship logic.

 

[nexshark]

I wish I were that close to correct. Dont believe the relationships I have set (PK's and FK's) support what I have explained. Otherwise I would have thought the form would work...it does not. I added test data directly into the tables, but still cannot even SEE the "form view" version of the Form. Dont have any idea what I am doing wrong here.
Already cut down by one table to try to get this to work (cases should have its own table for best flexibility later querying... Does any of this help you pro's to see what I am doing wrong?

Again, my profound thanks for your time.