Modification In Existing Data Base

[magdykhfee]

this is my new project ( truck weighting system )

In this system every truck must have ticket no ,,, when enter to the factor we must register its first weight then when we register the second weight when the truck get out of the factory

I use ODBC server and data base access for making database

I make export for data in the first weight ,,,, the problem now that i need to make modification in this data to add the second weight without adding anew line in the database

please help to find the sequence to make this modification

[AzeoTech]

You should use the db. functions to generate SQL commands directly, especially the db.execute() function (along with db.open()) Don't use a logging set at all. Then its just a matter of writing SQL, specifically the INSERT INTO and UPDATE commands. You'll need to make sure there is an identifying field so you can update it after it is created, an ID or similar.