The Mudcat Café TM
Thread #47406   Message #706916
Posted By: Jon Freeman
08-May-02 - 04:10 PM
Thread Name: tech: Access 97 Database: HELP!!!!!
Subject: RE: tech: Access 97 Database: HELP!!!!!
Kim, you have a customer diagnosis table too? If we are saying that you have customers and those customers each have a counsellor, each attend a support group, etc. I would say that counsellor, support group, etc. should be separate entities (or tables if you prefer).

I know you have been landed with this job but, really it pays to understand a little about relational database design before diving into a project. Have a look through your book on Access and see if you can find any mention of Entities or of Normalisation. If there is any mention, it will probably be near the back of the book.

If you really get stuck, if you like, you can send me an empty copy of the existing database together with some brief explaination as to how the database fits your real world working and I will attempt to come up with a design that follows established database rules.

Jon