Hi, i have already created a site http://www.techsteelengineering.com with asp and access database, though i know i have not constructed my database correctly to be very compatible in future developments to allow more felxability.



For example i have a project in progress section and Latest projects section where its two diffrent tables in the database but what i want to achive is to make its so the admin can upload the whole info with pix to lets say Projects in progress and when that actual project is done he can with a click of a button move it to the latest project section and just update the images.

But the way i have done it you need to do it twice.



Can anyone show me how to construct my database to be able to do this please.