Record History table

[Alexis1005]

We keep our vehicle and equipment in a Paradox 7/8 table and have fields for the driver's name, license number and date the vehicle was assigned. We reassign the vehicles periodically as well as add new ones. Is there a way to enter the driver's name, etc. in the Vehmaster.db and have it simultaneously update a vehicle driver history db? Or at least track the changes to the Vehmaster table records? Thanks for your help.

 

[TonyMcGuire]

You need to 'normalize' your data.

Do yourself a BIG favor and read the papers on this by Denn Santoro:

Data Normalization:

http://www.rdaworldwide.com/pdox/datanorm.pdf

Data Base Basics:

http://www.rdaworldwide.com/pdox/dbbasics.pdf

And general access to all articles/stuff:

http://www.rdaworldwide.com/pdoxres.htm

Tony McGuire

http://www.thedbcommunity.com

"It's not about having enough time. It's about priorities