copy a record as new version
have data in access database. this database has many tables i.e 50.
data filled in various froms in visual basic and then send to all these tables
related to one record.
i have a requirement of creating a new version of an existing record means
make a copy of the exisitng
record and save it as latest so that user can make changes in it and previous
record becomes a part of
I am able to find the latest exisitng record using a recordid field. After
that i need to append
a new record and copy the values of existing latest record into newly appended
record.Hwo can i achieve this in shortest way.
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL