1 Form to update 2 tables

[grogmi1]

Hello, I'm hoping someone can help me (Im not the best with MS access so please bear with me.

I have not yet started this database yet but what I need to do is have 2 tables, 1 which records 'live' data about our fleet of vehicles and 1 which contains the historical data, both tables will have identical fields. What I hoping to achieve is for 1 table to show the current serial numbers etc of parts in a vehicle and for one table to record the old serial numbers. I was wondering if you can create 1 form which captures the data but updates both tables at the same time ? (1 table will show the current parts, serial nos etc and 1 table will build up a constant history of parts that have been in that vehicle).

Is this even possible ???

Any help would be greatly appreciated, I hope I have posted in the correct forum as I know this question is quite broad covering forms and tables

 

[plog]

Is this even possible ???

Technically yes, but..

Im not the best with MS access

...practically, no.

First, what you want to do is probably intermediate-advanced level stuff. Second, what you want to achieve shouldn't be done in this manner.

If you want a historical record of serial numbers, then you would build a table specifically for that--not one that entirely duplicates your main table. This new table would have a 1 to many relationship and be capable of storing all your past serial numbers.

So, I think your ultimate issue is a data normalization issue, not a form manipulation one. Read up on database normalization.

 

[grogmi1]

Thanks for the reply. I've decided to scrap that plan based on your advice and go back to the drawing board. Thank you