Jul 24 2005, 06:22 AM
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
Jul 24 2005, 06:40 AM
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 ...
Jul 24 2005, 06:44 AM
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
Jul 24 2005, 06:46 AM
Sorry Ricky, I think I've just duplicated your quicker reply
Jul 24 2005, 06:48 AM
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
Jul 24 2005, 06:49 AM
No problem ..
Jul 24 2005, 06:52 AM
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 ...
Jul 24 2005, 07:32 AM
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?
Jul 24 2005, 07:38 AM
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
Jul 24 2005, 09:09 AM
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.
Jul 24 2005, 09:11 AM
Sorry, ignore me! I see that you will have a note per each visit in Medical History (if each record will be a visit)
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here