471,893 Members | 1,363 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,893 software developers and data experts.

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 929
NeoPa
32,470 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

reply views Thread by YellowAndGreen | last post: by
reply views Thread by zermasroor | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.