Hi
I'm currently working on setting up an Access database for a health related business but I'm having some problems figuring out how to structure the database. The business has been using an excel spreadsheet to store all its client data for the last 5 or so years but this has gotten too big to be effective. Currently I have a table called clients which is basically all of the information imported from the excel sheet. What I want to do is split parts of this table into other tables to make the information easier to read. Specifically I want to create new tables for Conditions (health conditions that clients may have) and Medications. At the moment these are stored just as strings in single fields and these is no structure or consistency to them. An entry for a client might contain only one condition or it might contain ten, all writen in a long senqence.
How can I structure my database so that a client can be linked to many distinct conditions? I need to be able to add new conditions to the Conditions table and have them automatically able to be linked to a client. I'm a bit confused about what I'm doing here which is probably obvious. I want to use a form to enter the data which will have a tab for both conditions and medications. These tabs will have a bunch of tickboxes for each condition or medication. The form operates on one client at a time so it should update to show which clients have which conditions and medications.
Hopefully I've explained this well enough