add data to different table in access database

[newbieVB]

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?

[NeoPa]

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.

[jforbes]

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?