Court Case database

[scubadiver]

A lady at work has asked me to comment on a database she has designed for
hold court case information. Like all newbies there is very little
normalisation going on!

I have set up the tables and tried to enter some info but it says the
details subform is not updateable. Here are my tables:

tble_CaseType
CaseTypeID
Casetype (PK)

tble_Casedetail
CasetypeID (FK)
CourtID (FK)
CaseID (PK)
Name
Date
AppNum
Casetype
Appeal
Issues
CourtDec
FinalDec
BoxNumber

tble_Court
CourtID (PK)
CourtName

tble_Ref
RefID (PK)
RefName

tble_CaseRef
CaseID (FK)
RefID (FK)

tble_judge
JudgeID (PK)
Title
Initial
Surname

tble_JudgeCase
JudgeID (FK)
CaseID (FK)

Cheers

 

[Duane Hookom]

Are we supposed to guess the record source of some subform?

BTW: Name and Date should not be used as field names since they are reserved
words.

 

[John W. Vinson]

I have set up the tables and tried to enter some info but it says the
details subform is not updateable. Here are my tables:

What's the Recordsource of the details subform? If it's a multitable query,
probably it shouldn't be; you can use Combo Boxes to display "looked up"
values, and you certainly should not base the subform on a query joining to
the mainform's recordsource.

John W. Vinson [MVP]