one table into four

vckidd

Registered User.
Local time
Today, 04:48
Joined
May 8, 2015
Messages
13
I am working on a database at work which at present is just one table and I think it would be better as 4. Is there an easy way to change the underlying structure of the database or would I be better creating a new database and if yes how would I migrate the current data?

Any ideas gratefully received.

Cheers
Viv
 
You have not provide anywhere near enough information to advise.

Tell us about what you have now and why you think four tables would be better.
 
There is not enough info here for making any sensible recommendations. What do you have (field names/types) what tables do you want (field names/types) and what are the relations to be?

Put your table into the Relations window, extend the table so all fields are visible, take a screenshot and attach it here (as zipped file).
 
I can't attach anything because I am a new user but here are the types of fields I have:

ID
name
address fields
contact fields
treatment
first A appt
how they heard
last a appt
a comment
first h appt
how they heard
last h appt
h comments
first n appt
n how
n comments
dob
MY first a appt
MY date pre-treatment
MY 6 week
etc

I am wanting to split the table into:

person
clinic person
clinic
(a many to many relationship with the middle table of clinic person)

plus MY data (a research thing that the clinic does) attached to the clinic person table.

You will see from the field list that it is pretty obvious that there are duplicated fields per clinic visit eg. first A appt; first H appt; first N appt hence the wanting a separate clinic table.

I have found a normalizing data post which seems to be what I am talking about.

Hope that is enough information. I am dyslexic so trying to get my ideas down on paper is not always easy.

Cheers
 
I noticed you haven't received any more feedback on your thread. This might be because others have assumed it's being handled. I thought it worth noting why I haven't responded. I noticed you have three fields for recording "where they heard about you", that doesn't make sense, you've got a single table in which you are collecting data from a customer and you ask them 3 times where they heard about you? That indicates to me that your existing set-up isn't working for you. In other words it needs lot more work before you can even think about how you would divide the data up.
 
Last edited:
"How we heard2 about relates to the separate treatment types but is one of the reasons I know I would be better with a separate treatment table. Is that what you meant?

A client can have treatment A, H and N or just one and each of those treatments has an associated "how did you hear" about it field which I think is daft.

I just don't know how to go about moving the data out.
 
I'm going to suggest you work through this tutorial on database and table design from RogersAccessLibrary. It should take (45 min to an hour). You have to work through it but you will learn some techniques that will help you identify tables, attributes/fields and relationships. You can apply what you have learned to your situation.


Good luck with your project.
 

Users who are viewing this thread

Back
Top Bottom