469,126 Members | 1,256 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,126 developers. It's quick & easy.

add data to different table in access database

I have a 3 tables in access database which is day-morning, swing-afternoon and grave-night. I want to save data based on the shift time for example I input 3:00 pm it will be save on the swing-afternoon table. is it possible? can anyone show me how to do it in vb?
Jun 16 '15 #1
2 881
NeoPa
32,161 Expert Mod 16PB
Let me advise strongly that diving into this without having any idea of how databases work first is a very bad idea. What you suggest is a very bad approach that will lead you into deep trouble. I'm sure someone will be along to give you some good tutorial links - or you may be able to find some using Google.

The first main point is that this data should never be split across multiple tables. That's just a big request for problems.

PS. I removed the shouting for you. It's not polite and doesn't make you come across too well. It's also against the site rules of course.
Jun 16 '15 #2
jforbes
1,107 Expert 1GB
Hey There,

Let me be the first to introduce you to Database Normalization: http://bytes.com/topic/access/insigh...ble-structures

The above is one of the Links NeoPa was referring to. In short it will explain to you why you should move the data you have in your three separate Shift Tables into one Table and include a column to record which shift the record belongs to. This will provide you a much easier way to write your Forms, Queries and Reports since you will only have to write them once instead of three times.

Not only that, the question that you are asking about will go away as you will only be adding data to one Table. The question will most likely be replaced by, how do I Filter the Form to only show one shift?
Jun 16 '15 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by CARIGAR | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.