Hi Everybody !

Newbie here, both to the forum ad Access.

I am looking to build a Customer Database for my therapy work.
Standard fields will be :

Name, Address, DOB, Phone No, Email, Dr. Name, Dr. Address, Medical History.

I would then like to add a note each time a client visits me to write about each treatment they have and how it went.

Is this possible?

Thanks for reading and any replies

{:@>

Welcome to Utter Access Forums ...

I hope that this is not your table structure .. as it is not properly normalized ...

The Customer information should be in 1 table ..
The Doctor information in another table ...
And the Medical History in still another table to enter the patient vists as a transaction ...

Also ... "Name" is Reserved Word in Access and should not be used in the naming of objects in your application ...

As for the Note question ...
This should be a memo field in the transaction table where the information is entered for each visit ...

RDH

Hi

Welcome to Utter Acess

Yes, it's the basic level of what relational databases are designed to do.

You would need to set your table structure up correctly before you start doing anything else though and make sure your structure is normalised. Search here at UA for normalising data where you will find many examples and explanations.

One other thing to be wary of is using reserved words as field or control names. It seems the most obvious thing to call a field Name, but that is a reserved word (along with lots of others) and if used will cause problems along the line.

Good luck with your project

HTH

Alan

Sorry Ricky, I think I've just duplicated your quicker reply

Hi there and thanks for your reply !!!!!!!!

I have a new field for each tile.

I can use a memo field for all the clients visits and scroll down to read them all, however, I wanted to add a new note each time I write something and link this to the client? Maybe this can be auto numbered?

What do you think?

Many Thanks From The UK

{:@>

No problem ..

RDH

Each visit should be a new, seperate record in a table ...
As I posted earlier .. you need to get your table structure correct before you proceed for this to work properly ...

RDH

Hi Everybody !

OK I will create a teable for
1) the client
2) Dr's details
3) Medical History

How do I make all this link up with each other?

{:@>

You have a ID in the client table (clientID) which is an autonumber and a primary Key

You have a ID in the Doctors table (DoctorID) which is an autonumber and a primary Key

You have 2 foreign keys in the Medical History Table, 1 for the DoctorID and one for the ClientID.

You can then link the tables together via the ID's

You will also need a notes table with NoteID (pk, autonumber) and NoteText (memo) fields.

This would then be linked via a junction table with NoteLinkID (pk, autonumber), ClientFK (number, long integer) and NoteFK (number, long integer) to the client table.

This way you can have many notes for many clients (many to many relationship) which is what I think you were driving at originally.

hth,

d

Sorry, ignore me! I see that you will have a note per each visit in Medical History (if each record will be a visit)

d